REST API

7 posts on REST API: benchmarks, internals and workarounds for the Microsoft data stack.

1. 07
   Fix Slow Refreshes: Faster Way to Load SharePoint Files in Power BI

   Optimize Power BI SharePoint data retrieval. Learn technical differences between connectors and implement a custom REST API strategy for faster dataset refreshes.

   Dec 30, 2025
2. 06
   How to Fix Slow SharePoint List Refresh in Power BI

   Boost Power BI SharePoint refresh speed. Fix RenderListDataAsStream errors and use a custom M script to cut load times from minutes to seconds.

   Dec 23, 2025
3. 05
   Programmatically Refresh & Sync SQL Analytics Endpoint Metadata in Microsoft Fabric

   Learn how SQL Analytics Endpoint in Microsoft Fabric works and how to fix metadata lag by calling the Refresh SQL Endpoint Metadata API before Power BI refresh.

   Nov 17, 2025
4. 04
   How to Connect GraphQL APIs as a Data Source in Power BI

   Learn how to connect GraphQL APIs to Power BI effortlessly. Discover key GraphQL concepts and integrate GraphQL with Power BI for seamless data analysis.

   Aug 3, 2025
5. 03
   API Authentication in Power Query

   The five authentication methods Power Query supports: Anonymous, API Key, Bearer Token, Basic and OAuth 2.0, with working M for each.

   Nov 25, 2024
6. 02
   Pagination in Power Query

   How to page through an API from Power Query: offset, cursor and link-header styles, with M that keeps asking until the last page comes back.

   Nov 12, 2024
7. 01
   Introduction to API in Power Query

   Calling a REST API from Power Query with Web.Contents and Json.Document: the request, the response, and turning JSON into a usable table.

   Nov 9, 2024