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 

     

     

KristinaBakic's avatar
KristinaBakic
Frequent Visitor
11 years ago

You can add reports from various sources to one dashboard. Once the dashboard is created, have the said dashboard selected and choose "Get Data" and add the report!

 

As far as I know, you have to add the report from your source (OneDrive etc), not straight from the PowerBI service - so if you want to use a report in several dashboards, you have to upload them separately to each one. I hope that adding from once uploaded reports will be available at some point.

 

 

andre's avatar
andre
Icon for Memorable Member rankMemorable Member
11 years ago

KristinaBakic, you should not have to keep re-uploading your reports.  If you have report ABC in your Reports section, and two dashboards, A and B, you can click on the desired dashboard and make sure it's selected, then you can click on the report ABC and pin any tiles to the previously selected dashboard, so your dashboards A and B would point to the same report ABC.