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 

     

     

Anonymous's avatar
Anonymous
Not applicable
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 

 

 

STekals's avatar
STekals
Regular Visitor
11 years ago

Thanks Vishal having everthing with sanpshots , all your answer are really useful and easy to understand.