Forum Discussion

CatherineT's avatar
CatherineT
Frequent Visitor
6 months ago
Solved

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 ...
Show and Tell
Tutorial Requests
  • v-saisrao-msft's avatar
    v-saisrao-msft
    5 months ago

    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.

cengizhanarslan's avatar
cengizhanarslan
Super User
6 months ago

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.