Forum Discussion
ipon70
2 years agoHelper I
Dynamically Change Query Source
Hopefully I didn't miss this being answered elsewhere. What I am trying to do is have an excel file called "Feed". Inside the "Feed" file in the first column and row is a link "\\network\scr\data\cu...
- 2 years ago
You can parameterize the source and then save your file as a Power BI Template. That way the user will be asked to provide the parameter value upon opening.
lbendlin
2 years agoSuper User
Is that only for local processing or are you expecting this to work in the Power BI Service (hint: it won't) ?
- ipon702 years agoHelper I
This would be if someone downloads the report to work on their local desktop and it needs a different source before being uploaded.
- lbendlin2 years agoSuper User
You can parameterize the source and then save your file as a Power BI Template. That way the user will be asked to provide the parameter value upon opening.
- ipon702 years agoHelper I
I haven't used that feature so let me play with that idea and post back if it doesn't work, or accept it as a solution. Thanks again for the direction and help.