Forum Discussion

mowlana's avatar
mowlana
Frequent Visitor
8 years ago
Solved

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 app...
Need Help
Tips and Tricks
  • wilson_smyth's avatar
    wilson_smyth
    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

     

mowlana's avatar
mowlana
Frequent Visitor
8 years ago

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?

 

 

v-piga-msft's avatar
v-piga-msft
Icon for Resident Rockstar rankResident Rockstar
8 years ago

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