Forum Discussion
Can't save dataflow - One or more tables references a dynamic data source.
Please follow the documentation. Use RelativePath and Query parameters. https://learn.microsoft.com/en-us/powerquery-m/web-contents#example-1
I just did , I basically hardcoded the date and it was fine. I want to refresh automatically but only the last days. ANyt suggestions
SaiTejaTalasilaSuper User
Hi Anonymous ,
Try the same thing on power bi semantic model and see whether the same issue occurs or not.If it's not working then I don't think you have any other options other than hard coding the value of parameter or url.
Please refer this threads-
I hope it will be helpful.
Thanks,
Sai Teja
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
Hi 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