Forum Discussion

joncmaloney's avatar
joncmaloney
New Member
4 years ago

Incremental Refresh Using M Query and paginated API

I'm trying to use an M Query to pull data from a paginated API. Currently the M Query works to pull all the paginated API data using Json.Document(Web.Contents(Url)) The above line is run through a...
Need Help
joncmaloney's avatar
joncmaloney
New Member
4 years ago

Hi lbendlin, 

 

Thanks for the reply. To be more specific when I have added RangeStart and RangeEnd based on this guide: 

https://docs.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-configure I append RangeStart and RangeEnd to the URL string that is used in: Json.Document(Web.Contents(Url)) as a query param. I can change the RangeStart and RangeEnd parameters reload the data and the dataset loaded into Power BI desktop shows new data based on the updated parameters. After I have setup the M Query I then publish the Power BI Query to a service (I believe incremental refresh is only possible when using a service). However when I have a look at the service I see the following error message about scheduled refresh. 

 

Does this error message mean that the Url i'm using cannot be reached by the service or does it mean that M Queries cannot be used with scheduled refresh?

 

Thanks again for your assistance so far with this issue. 

 

Kind Regards, 

Jon

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago

where does the link go?

  • joncmaloney's avatar
    joncmaloney
    New Member
    4 years ago

    Link goes to the server with the API. However when we are using the destop version the pc would route to the API differently compaired to a service hosted in the cloud. So i'm guessing what your saying is that yes the service can't see the API and that's why I'm getting the error? I just need to fix connectivity?

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      4 years ago

      Sorry, I meant where the "Discover Data Sources"  link goes.