Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Parameterization of Data Source Connection

Hi,   We have 2 environments QA and Prod and a single report. The schema and tables in both environments are same and data is different. Can I by any chance use  a parameter to switch between the...
  • v-frfei-msft's avatar
    v-frfei-msft
    8 years ago

    Hi Anonymous,

     

    Based on my test, we can add parameters firstly in power query. I take SQL Server as an example, you can apply the same process to your Redshift data source.

     

     

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

     

     

    Regards,

    Frank

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi,

 

We have 2 environments QA and Prod and a single report.

The schema and tables in both environments are same and data is different.

Can I by any chance use  a parameter to switch between the data sources?

I'm using redshift

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

Hi Anonymous,

 

Based on my test, we can add parameters firstly in power query. I take SQL Server as an example, you can apply the same process to your Redshift data source.

 

 

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

 

 

Regards,

Frank

  • v-frfei-msft's avatar
    v-frfei-msft
    Community Support
    8 years ago

    Hi Anonymous,

     

    Does that make sense? If so, kindly mark my answer as a solution to close the case please.

     

    Regards,

    Frank