Forum Discussion
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 data sources?
I'm using redshift
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
3 Replies
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
Hi Anonymous,
Does that make sense? If so, kindly mark my answer as a solution to close the case please.
Regards,
Frank