Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
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
Hi @Anonymous,
Does that make sense? If so, kindly mark my answer as a solution to close the case please.
Regards,
Frank