Forum Discussion
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...
Hi marcosimeone ,
The Web.Contents used in the source of function needs the base url to stay the same and then any dynamic parts put into the options.
This blog post consolidates all relevant info about dynamic datasources, please kindly refer to:
Dynamic Web.Contents() and Power BI Refresh Errors – Data Inspirations
Web.Contents(), M Functions And Dataset Refresh Errors In Power BI
Using The RelativePath And Query Options With Web.Contents() In Power Query And Power BI M Code
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.cc