Forum Discussion

Alex_G7's avatar
Alex_G7
Helper I
7 years ago
Solved

Replace Data Source of Each Query with Generic Data Source

Hi  I am selecting from view in my projects  I want change Data source for all queries to generic Data Source when I will move from dev to prod     1. I created Blank Query  DS_AG usinng Advic...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    Hi Alex_G7 ,

     

    Based on my test, we can add parameters firstly in power query. I take SQL Server as an example here as the same as yours.

     

    123.png

     

    Then we can get data and use the Parameter that we created. For more details, please check the online document.

     

    12333.png

v-frfei-msft's avatar
v-frfei-msft
Community Support
7 years ago

Hi Alex_G7 ,

 

Based on my test, we can add parameters firstly in power query. I take SQL Server as an example here as the same as yours.

 

123.png

 

Then we can get data and use the Parameter that we created. For more details, please check the online document.

 

12333.png

Alex_G7's avatar
Alex_G7
Helper I
7 years ago

Thank ypu 

 its is very simply and wokring solution