Forum Discussion
DPCCGF
Helper IV
Helper IVDynamic Data Sources and API
Hello! I am trying to figure out how to modify the below code so that I can refresh in the PowerBI service without the Dynamic Data Source error. Getting 100 rows at a time and just paging for new re...
lbendlin
Super User
Super UserFair enough. So you can use multiple approaches for paging - here is one I like (even comes with its own little helper function )
Handling paging for Power Query connectors - Power Query | Microsoft Learn
DPCCGFHelper IV
Helper IVThanks! I will check this out. This is my first "foray" into getting data via an API and my guess is it will not be my last. So I really appreciate your help. For now it appears that I am paging though correct? If so I will leave as is as I have a data model to change quickly, but will begin testing out your suggestion next week.