Get it from the Microsoft Store (search Power BI Desktop) or from powerbi.microsoft.com/desktop. Open it and close the welcome screen. You are looking at a blank report.

Every table below is a link. Power BI reads it as a spreadsheet. Here is the click path, drawn out:

When all five are in, the Data pane on the right lists Teams, Scores, Schedule, WeeklyWinners, SuperBowl. That is your model.

Every table carries a gold teamKey column (league id plus team id), so a team is one thing across all eight leagues. Power BI usually spots the match and draws the lines itself. To check, open the Model view: the third icon on the left rail.

Power BI sums numbers on its own, so none of this needs a formula. When you want more, here are a few measures to paste in with Modeling New measure.

Total Points = SUM ( Scores[points] )

Games Played = CALCULATE ( COUNTROWS ( Scores ), Scores[final] = TRUE (), NOT ISBLANK ( Scores[points] ) )

Points per Game = DIVIDE ( [Total Points], [Games Played] )

Win % = DIVIDE ( CALCULATE ( COUNTROWS ( Scores ), Scores[result] = "W" ), [Games Played] )

Bench Points = SUM ( Scores[bench] )

Week High = CALCULATE ( MAX ( Scores[points] ), ALLEXCEPT ( Scores, Scores[week] ) )

PF Rank (all 80) = RANKX ( ALL ( Teams[teamKey] ), [Total Points], , DESC, DENSE )

Points vs Field Avg = [Points per Game] - CALCULATE ( [Points per Game], ALL ( Scores ) )

8 Home Refresh pulls the latest numbers. The site itself refreshes from ESPN about every ten minutes, so during games that is how live it gets.

Publish to the Power BI service and set a scheduled refresh under the dataset settings. Because the source is public web data, no gateway is needed. Set the web credentials to Anonymous, and if the connection test complains, tick Skip test connection.

(endpoint as text) as table =>
let
    Raw = Web.Contents("https://csgfantasy.com", [RelativePath = "api/v1/" & endpoint, Query = [format = "csv"]]),
    Csv = Csv.Document(Raw, [Delimiter = ",", Encoding = 65001, QuoteStyle = QuoteStyle.Csv]),
    Table = Table.PromoteHeaders(Csv, [PromoteAllScalars = true])
in
    Table

Type this in cell A1. Sheets fills the table and re-fetches on its own about once an hour.

=IMPORTDATA("https://csgfantasy.com/api/v1/teams?format=csv")

Swap teams for rosters, scores, points-leaders, weekly, superbowl, schedule, or leagues/CSG2/standings. Add &season=2025 for last year.

Python, R, a notebook, a cron job: plain JSON and CSV over HTTPS with open CORS.

import pandas as pd
scores = pd.read_csv("https://csgfantasy.com/api/v1/scores?format=csv")

Every unplayed matchup carries an alarm for Friday at 8 AM Central, two days before Sunday's slate. Once the game is played, the title becomes the score and the reminder goes away.

Once ESPN finalizes a week, the top score across all eight leagues appears on the Tuesday after, on every feed. Yes, even on the feeds of the people who lost.

Every team has a link. Send someone theirs and they are subscribed in one tap. Pick their team above, copy, paste into the group chat. The commissioner's Tuesday winner event is the same on everyone's calendar, which settles a surprising number of arguments.

The site is built for phones. Added to the home screen it gets an icon and opens full screen like an app.

Build the sheet once on a computer, then it is a live spreadsheet in the Google Sheets app. Sheets refreshes the data on its own about once an hour, and pull-to-refresh in the app checks again.

1. On a computer, open sheets.new and put this in cell A1.

=QUERY(IMPORTDATA("https://csgfantasy.com/api/v1/points-leaders?format=csv"), "select E,B,G,H,J order by H desc limit 10", 1)

2. Add tabs for anything else you want. Each is one formula.

=IMPORTDATA("https://csgfantasy.com/api/v1/weekly?format=csv")

=QUERY(IMPORTDATA("https://csgfantasy.com/api/v1/leagues/CSG2/standings?format=csv"), "select E,G,I,J,K order by I desc", 1)

3. Open the Google Sheets app on your phone. The sheet is there, live. Star it so it stays at the top.

Swap CSG2 for your league. Add &season=2025 inside the link for last year. The column letters above match the CSV column order: E team, G record, H points for, I points against, J average.

A Shortcut that reads the digest out loud, shows it, or drops it in a widget. The API has a phone-sized summary endpoint that returns plain text, so the Shortcut is two steps.

1. Open Shortcuts, tap +, name it CSG Fantasy.
2. Add the action Get Contents of URL and paste the link below.
3. Add the action Show Result. Done. Say "Hey Siri, CSG Fantasy" or tap it.

https://csgfantasy.com/api/v1/summary?format=text

https://csgfantasy.com/api/v1/summary?format=text&league=CSG2

https://csgfantasy.com/api/v1/summary

Install HTTP Shortcuts (free, open source, on Google Play and F-Droid). It puts a web request on your home screen as an icon or widget.

1. Tap +, choose Regular shortcut, name it CSG Fantasy.
2. Set the URL to the text summary below. Leave the method as GET.
3. Under Response Handling choose Show in a dialog window (or a toast for just a glance).
4. Back on the list, long-press the shortcut for Place on home screen.

https://csgfantasy.com/api/v1/summary?format=text

Tasker users: an HTTP Request action to the same URL, then Say with %http_data, on a Tuesday 8:00 profile. Android widgets like KWGT can also read the JSON form directly.

If you followed the Power BI tutorial, the report you built can live on your phone with live data.

1. In Power BI Desktop, click Publish and choose My workspace. A free Power BI account with your work email is enough for your own use.
2. Still in Desktop, View › Mobile layout lets you drag the visuals you want into a phone-shaped canvas. Publish again after.
3. On the phone, install Power BI (iOS or Android), sign in, open My workspace, and tap the report. Tap the star so it lands in Favorites.
4. In the Power BI service on the web, open the dataset's Settings › Scheduled refresh and set it to refresh daily. The source is a public link, so pick Anonymous under credentials. The phone then always shows current numbers.

Excel on the phone can open the workbook from the spreadsheet tab too, but it cannot refresh a web query on its own. Refresh on the computer and the phone sees the saved numbers.

• Just want to look: add the site to your home screen.
• Want your own table you can sort and scribble on: Google Sheets.
• Want it spoken to you on Tuesday morning: the Shortcut, or HTTP Shortcuts on Android.
• Want charts and slicers in your pocket: Power BI mobile.

Python, if you insist on being normal:

import pandas as pd
scores = pd.read_csv("https://csgfantasy.com/api/v1/scores?format=csv")
print(scores.groupby(["league", "team"])["points"].mean().sort_values(ascending=False).head(10))