Forum Discussion
Can't save dataflow - One or more tables references a dynamic data source.
In Dataflow I am trying to set up an automatic refresh, but I am not able since I get an error message. In my URL I only want the last 2 days of data. It is working fine inside PowerBi when I refres...
Please follow the documentation. Use RelativePath and Query parameters. https://learn.microsoft.com/en-us/powerquery-m/web-contents#example-1
It is the same in power BI semantic. I just need to find a workaround. Maybe I can generate the URL in excel, and import the whole string?
SaiTejaTalasila
Super User
Super UserHi Anonymous ,
You can try that- upload that file to SharePoint folder whenever someone opens that file in desktop you can make power query to run on their local machine automatically and updates the result, but they should have access to SharePoint and your data source(web url).
Thanks,
Sai Teja