Forum Discussion
Different data sources with the same visualisation in one page
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
Resident RockstarHi 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
Hi wilson_smyth Chaning connection server name via parameter is achived using parameter but Since my Schema name is not identical in UAT and Live I want to change Schema name too at once. Is this doable?
Please see my original post here: https://community.powerbi.com/t5/Desktop/Schema-change-to-multiple-queries-SAP-hana-and-Direct-query/m-p/749956#M361491
Note: I am using SAP HANA with Direct query.
Thanks,
Kul
- wilson_smyth
Anonymous
The report depends on the underlying schema. If its looking for a TableA.ColumnA, but this doesnt exist after you point to a new environment, the report will break.
There are probably ways to work around this in some cases, but its not recommended. reports really need a stable schema.
if the only thing that changes are columns or tables that you are not using, then you should have no problems.
- v-piga-msft
Hi mowlana,
Have you solved your problem?
If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If you still need help, please feel free to ask.
Best Regards,
Cherry