Search with pagination in Power BI

[mcheek (Mark Cheek)]

Just curious, does this work without the use of the searchAfter? Meaning up to 10k records?

I have a working pagination example in this topic if you want to try and adapt it to your use case

Extracting Data from IDN to PowerBI

@jodi_pruitt The trickiest part is that Power BI’s “Web” source does not allow oauth-type authentication, only basic and api key-based auth. In order to get around this, I had to create a “Blank Query” and do everything in Power Query. Here are some of the snippets… First, you need to get a token using your client credentials getToken = Json.Document( Web.Contents( param_root_uri, [ RelativePath="/oauth/token", Query=[ …