Forum Discussion
Can I combine 2 different data sources in the same Power BI dashboard?
I have a Microsoft Project Online OData feed and and excel file containing SAP data. Can Power BI show both data in the same data dashboard?
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
Now i have take second source as excel
Now you can use merge query to relate them together as shown
Now you are ready for Dashboard combining data from Both Source.
Hope this helps !
Vishal
9 Replies
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
Now i have take second source as excel
Now you can use merge query to relate them together as shown
Now you are ready for Dashboard combining data from Both Source.
Hope this helps !
Vishal
Thanks Vishal having everthing with sanpshots , all your answer are really useful and easy to understand.
You can combine them with Power Query, and then use the result set in dashboard
Or
you can create a relationship between these two data source in Power BI designer and then your chart will be able to show related information
You can also combine different visualisations form different reports one the same dashboard. However, you can't establish relationships between them that way.
- 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!
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.
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.
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?
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....
