undefinedQuickly change data source environnement for SQL requests on desktop application

[CatherineT]

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 ?

[v-saisrao-msft]

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.

[MasonMA]

Hi, 

You can also follow this Youtube Tutorial from Microsoft~

https://www.youtube.com/watch?v=OnaDJkGOmIE

[CatherineT]

The video si no more available 😞

[MasonMA]

sorry, this would be the link Making data source parameters easy in Power BI Desktop 

[cengizhanarslan]

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.