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.

MariaIsabel's avatar
MariaIsabel
New Member
4 years ago

Hi Caitlyn,

 

I followed the instructions posted on the 3 links that you refered but I still have a problem with one of my sources: https://www.cuandoenelmundo.com/calendario/espana/2021. It doesn't have a query at the end but just change the url for every year. I wasn't able to use the Relativepath - query instructions with this one. Could anyone help to solve this please. 

I am trying to include a calendar with hollidays into my report that can be updated automatically.

 

Thanks in advance for your help

  • mellon199's avatar
    mellon199
    Frequent Visitor
    3 years ago

    Hi MariaIsabel

     

    Were you able to find a solution for your query?