Forum Discussion

marcosimeone's avatar
marcosimeone
Frequent Visitor
4 years ago

Dynamic data source that cannot be refreshed in the Power BI service is present

i am trying to connect to SAP Success Factor via OData with standard web connector. this connector allows the reading of 1000 records at a time, I found a recursive function in this blog that allows...
General Comment
Need Help
Tips and Tricks
Tutorial Requests
lbendlin's avatar
lbendlin
Super User
4 years ago

Change your Web.Contents call to use a fixed base URL. Supply the filters via the Query parameter option. Do the same for the subsequent pagination, instead of using 

Web.Contents(_[__next])
Jessica005's avatar
Jessica005
Regular Visitor
3 years ago

How would you create a fixed URL when it is grabbing the next API request from the row _next ? I see that is is causing my data source to be dyanmic as well and I am not sure how to adapt this one. Thank you. 

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago

    follow the links that Anonymous posted.