Forum Discussion

AllanRocha's avatar
AllanRocha
Regular Visitor
11 years ago
Solved

Can I combine 2 different data sources in the same Power BI dashboard?

I would like to combine 2 different data sources in the same Power BI dashboard. Can I do that? I have a Microsoft Project Online OData feed and and excel file containing SAP data. Can Power BI show ...
  • Anonymous's avatar
    Anonymous
    11 years ago

    Yes Power BI can combine both Data, Here how i have done it to show you in Power BI Designer 

    I have take one ODATA Feed 

    ODATA Feed Example

    Now i have take second source as excel 

    ExcelAsDataSource.png

    Now you can use merge query to relate them together as shown Use of Merge Queries

    Now you are ready for Dashboard combining data from Both Source.

    Data From both Source.png

    Hope this helps !

     

    Vishal 

     

     

diverdown1964's avatar
diverdown1964
Icon for Most Valuable Professional rankMost Valuable Professional
11 years ago

You can also combine different visualisations form different reports one the same dashboard. However, you can't establish relationships between them that way.