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 

     

     

ashishrj's avatar
ashishrj
Icon for Power Participant rankPower Participant
11 years ago
Yes you can combine data from different sources using merge data option as explained by vishal and later create relationships between them or import data and create reports seperately and later on powerbi.com pin these into a single dashboard!