Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi everybody,
do you know or is there any possibility to change data source using script? I would like to have a folder with script or instruction. And in the same folder would be pbix file. When I open pbix file, It would ask script for data source.
Can you help me with that?
Thank you for your time,
Mary
Solved! Go to Solution.
Hi hanzlova,
“I would like to have a folder with script or instruction. And in the same folder would be pbix file. When I open pbix file, It would ask script for data source.”
<--By now power bi don’t have that feature. You can vote on these two similar ideas:
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/7345565-power-bi-designer-api
As a workaround, to achieve your requirement, you can use “Query parameter” in edit query. Follow steps below:
2. Enter new parameter name(e.g.: Server Name), select “List of values”, then enter server names or database names. You can enter multiple server names or database names in “List of values”. You can also set “Default Value” and “Current Value” in this pane.
3. Right click parameters in “Queries” pane and click enable load.
4. Finally you can select server and database using query parameters like below, the parameter value is “current value” you have set. If you want to change “current value”, you can change it in “Manage Parameter” pane.
You can refer to the blog for more details about Query Parameter:
https://powerbi.microsoft.com/en-us/blog/deep-dive-into-query-parameters-and-power-bi-templates/
Regards,
Jimmy Tao
Hi hanzlova,
“I would like to have a folder with script or instruction. And in the same folder would be pbix file. When I open pbix file, It would ask script for data source.”
<--By now power bi don’t have that feature. You can vote on these two similar ideas:
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/7345565-power-bi-designer-api
As a workaround, to achieve your requirement, you can use “Query parameter” in edit query. Follow steps below:
2. Enter new parameter name(e.g.: Server Name), select “List of values”, then enter server names or database names. You can enter multiple server names or database names in “List of values”. You can also set “Default Value” and “Current Value” in this pane.
3. Right click parameters in “Queries” pane and click enable load.
4. Finally you can select server and database using query parameters like below, the parameter value is “current value” you have set. If you want to change “current value”, you can change it in “Manage Parameter” pane.
You can refer to the blog for more details about Query Parameter:
https://powerbi.microsoft.com/en-us/blog/deep-dive-into-query-parameters-and-power-bi-templates/
Regards,
Jimmy Tao
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |