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 

     

     

powerbient's avatar
powerbient
Frequent Visitor
9 years ago

Anonymous ashishrj andre

Imagine i have a huge dataset developed in Power BI Dataset(~400MB) and published it to Power BI Service. Later i realized that i need to add an extra Dataset(~5MB) to get my Report work but i dont want to add it by coming back to Power BI Desktop and publishing it which would take longer time. so i what i would want is add a new Dataset(~5MB) in Power BI Desktop and publish it and later merge it in Power BI with the huge Dataset(~400MB) which would take considerable less time. Is that possible?

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

Best way to achieve that would be to allow Power BI Desktop to connect to models that have been deployed to powerbi.com the same way (or in a similar way) Excel connects to them using Analyze in Excel driver.

 

Does this feature make sense? Absolutely... What's the timing on this?  We don't know....