Forum Discussion

n0ab's avatar
n0ab
New Member
4 years ago
Solved

Scheduled Refresh using Dynamic Data Source

Hello all-   A reporting project I'm currently working on uses a web hook to pull in ~50k records via AWS using a lambda function. As some of you may know, AWS has a forced 30 second timeout. This ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi n0ab ,

 

To refresh dynamic data sources in Power BI Service, you can use Web.Contents() and Relative Path parameter in it, please refer:

  1. Setting a scheduled refresh on a Dynamic Data Source in Power BI 
  2. Web.Contents(), M Functions And Dataset Refresh Errors In Power BI 
  3. Using The RelativePath And Query Options With Web.Contents() In Power Query And Power BI M Code 

 


Hope it helps,


Community Support Team _ Caitlyn Yan


If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

Gabe_V's avatar
Gabe_V
Helper I
1 year ago

Hi Anonymous are there any similar solutions when using SharePoint.Tables? 

I am receiving the same error, but when using SharePoint.Tables instead of Web.Contents.

I have tried such things as putting Web.Contents inside of SharePoint.Tables and putting the root URL in a parameter and referencing that. Neither work.

 

Any assistance you could provide would be greatly appreciated.

Thanks!