Forum Discussion

h4tt3n's avatar
h4tt3n
Helper V
5 years ago

How to overcome API call row limit?

Hello,   I am attempting to extract measurement data from an API with a limit of 1000 rows per call. Each row consists of a data value and a timestamp. I have set up a Power Query script that conne...
Need Help
  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    mahoneypat Thanks for that wonderful video. I have implemented skip and offset method while pulling data from API. Earlier it used to limit 100 records but using this I am able to load complete data. Next challenge is refresh doesn't work in Power BI Service. Returns error saying This dataset contains dynamic data source. 

    Any suggestions so that refresh works..Please note I already tried approach mentioned in below link

    https://blog.crossjoin.co.uk/2016/08/23/web-contents-m-functions-and-dataset-refresh-errors-in-power-bi/

    but then after adding skip and top as query parameters.. it pulls same set of records everytime.. so this is not working for me. Do you suggest any other option which will resolve dynamic data source issue in Service?