Parameterization of Data Source Connection

[Anonymous]

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

[Anonymous]

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 · Accepted solution]

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]

Hi @Anonymous,

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

Regards,

Frank