Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |