Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
72 | |
38 | |
31 | |
26 |
User | Count |
---|---|
97 | |
86 | |
43 | |
40 | |
35 |