Forum Discussion
Different data sources with the same visualisation in one page
Imagine, you have two Exel files with same columns.
Is it possible in Power BI to have one page with some charts, but you can select that the charts with which excel file should be filled.
I appreciate really any help!
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
9 Replies
v-piga-msftResident Rockstar
Hi mowlana,
but you can select that the charts with which excel file should be filled.I'm a little confused about this sentence.
From I understand that you have two excel tables with the same columns and what do you want to do in one page?
If it convenient, could you share some data sample and your desired output?
Best Regards,
Cherry
Hi v-piga-msft,
sorry, i wrote it a little bit unclear. I actually mean if it is possible to change datasource within Power BI just as a dropdown menu?
wilson_smythPost Patron
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
