Power Query (M)
Open Power BI / Excel → Get Data → Blank Query → Advanced Editor, then paste the file's contents. Replace the example API domain with yours.
🔒 Downloads are free — just sign in first. Clicking a download will take you to sign-in and bring you right back.
Authentication
- Sign in to download
API Key (ApiKeyName)
ApiKeyName = "api_key"; set the key with a Web API credential.
- Sign in to download
Basic Auth
Managed Basic credential, or the manual Authorization header.
- Sign in to download
Bearer Token
Bearer token in the Authorization header.
- Sign in to download
OAuth2 Client Credentials
POST /oauth/token for an access token, then call with Bearer.
Pagination
- Sign in to download
Page-number
List.Generate increments page until has_next is false.
- Sign in to download
Offset / limit
List.Generate increments offset by the limit.
- Sign in to download
Cursor
Follow the relative next until null (Link-header isn't practical in M).
Data manipulation (advanced M)
- Sign in to download
Group & Aggregate (Table.Group)
One row per department: sums, average, count, variance %.
- Sign in to download
Merge / Join (NestedJoin + Expand)
Enrich campaigns with the channel type from another table.
- Sign in to download
Pivot & Unpivot
Daily spend → one column per channel (Table.Pivot); reverse included.
- Sign in to download
Types, custom & conditional columns
Fix types, % change, up/down flag, weekday from a date.
- Sign in to download
Running total (window)
Cumulative spend over sorted dates via List.FirstN + List.Sum.
- Sign in to download
Top-N per group (nested tables)
Top 3 run-scorers per team — greatest-n-per-group in M.
Web Scraping
- Sign in to download
Html.Table (text + attribute)
Extract title/price text and the image src attribute from /samples/store.
Capstone
- Sign in to download
ApiKeyName + Paginate + Flatten
Page the nested-list shape and expand it into a flat table.