Forum Discussion
How to enable dynamic source path using Sharepoint folder as data source?
Hi Anonymous ,
You could create a query parameter under Edit queries->Home->Manage parameter->New Parameter
Power BI Introduction: Working with Parameters in Power BI Desktop —Part 4
Then use this parameter ((file parameter) in the Source code.
Reference:
https://radacad.com/change-the-source-of-power-bi-datasets-dynamically-using-power-query-parameters
https://www.excelguru.ca/blog/2018/05/30/creating-dynamic-parameters-in-power-query/
As for use a Relative Path, I hope this thread will be helpful.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If you publish your pbix file, power bi service do not refresh, here the message This dataset includes a dynamic data source. Since dynamic data sources aren't refreshed in the Power BI service, this dataset won't be refreshed. Learn more: https://aka.ms/dynamic-data-sources.
- Data source for Query1How do you fix this? please
were you able to find a solution?
I'm having this dynamic source refresh issue in power bi service when I get data from SharePoint.Tables