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.
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.