Forum Discussion
Dynamically change data source
Hi Anonymous
Yes, your requirement can be achieved.
i make a test.
create parameter called "csvname"
use this parameter in the Advanced editor
Reference:
Power BI – Using Parameters for Flat File / CSV / Excel Sources
https://powerbi.microsoft.com/en-us/blog/deep-dive-into-query-parameters-and-power-bi-templates/
Best Regards
Maggie
Hi Maggie
Thank you for your reply, that indeed works. But what I am looking for is a little less work (things that can go wrong) if my colleagues applies new sources.
I've heard a little about you can create query parameters, and save the report as a template. So when it opens it will prompt for the location of the .csv files. This is closer to what I am looking for, but would still prefer something similarly to what you can do with Powershell and using the ".\" path that points to the location of the script. Here it would instead be the location of the power-bi report.
Hi Anonymous
Yes, your requirement can be achieved.
i make a test.
create parameter called "csvname"
use this parameter in the Advanced editor
Reference:
Power BI – Using Parameters for Flat File / CSV / Excel Sources
https://powerbi.microsoft.com/en-us/blog/deep-dive-into-query-parameters-and-power-bi-templates/
Best Regards
Maggie