Forum Discussion
Different data sources with the same visualisation in one page
- 8 years ago
If i read you correctly, you want an easy way to point to a different environment but with identical schema, such as repoint a report from dev to UAT to Production data sources.
There is no dropdown, but the dropdown under the "Edit Queries" button allows editing of data sources. In here you can change various parameters, depending on what options the source allows you to alter.its also possible to use a parameter to change connection, which may help provide what you require, have a look at this article:
https://community.powerbi.com/t5/Community-Blog/Using-the-Power-BI-Service-Parameters-to-change-connection/ba-p/392016
in that case, when you mean database schema used to organize objects and for security, yes, that can be parameterized, i.e. create a parameter and reference it in your power query.
there are some details in this post on the community.
wilson_smyth I think I was making it complicated by mentioning schema change. What i simply want is to pass parameter in to my query. Is this make sense?