Forum Discussion
undefinedQuickly change data source environnement for SQL requests on desktop application
If I declare 2 data sources, one on DEV environnement and the other one in production environnement, is it possible to change quickly from one to the other easily in the sql requests, on the desktop application ?
Hi CatherineT,
Based on your previous update, can you confirm if the issue is resolved on your side, or do you still require any assistance?
Thank you.
8 Replies
Can be done if you define parameters in Power Query for your 2 different sources. Then just by changing the parameter the source could be change DEVtoProd or ProdtoDEV.
Hi,
You can also follow this Youtube Tutorial from Microsoft~
The video si no more available 😞
sorry, this would be the link Making data source parameters easy in Power BI Desktop
Hi CatherineT,
Have you had a chance to review the solution we shared by cengizhanarslan MasonMA ? If the issue persists, feel free to reply so we can help further.
Thank you.
Hello,
I managed to create the 2 proposed parameter (ServerName and DatabaseName) and create a connection on each environments. This allow me to change the connection in the desktop application.Next step, will be to see I how to publish the report in the DEV environment and push it in the production one, using existing connections in the gateways.
Thank you for your help !
Hi CatherineT,
Based on your previous update, can you confirm if the issue is resolved on your side, or do you still require any assistance?
Thank you.
Hi CatherineT,
Checking in to see if your issue has been resolved. let us know if you still need any assistance.
Thank you.
