Can I combine 2 different data sources in the same Power BI dashboard?

[mwun]

...

[ashishrj · Accepted solution]

@mwun A combined answer for the above two replies.

1. In Power BI Online, you can combine visualization from different reports in your Power BI account into one single dashboard (using pin) irrespective of the data sources 

2. To do so in single report, you can use Desktop tool having 'Merge Queries' functionality in Query Editor to achieve the same

Hope this works!

[admin123]

I have another question over here that can we combine two datasource in direct query mode in a single power bi desktop report ?

[patrickoliver]

Unfortunately not - see https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/12272427-allow-joining-multiple-d...

[admin123]

I have another quetion over here that can we combine two datasource in direct query mode in a single power bi desktop report ?

[Seth_C_Bauer]

You can pin any report visual to any dashboard. Those reports can come from any data source. So if that is what you mean by combining data sources - "yes"

[Haegi]

Hello,

If you want to combine in only one dataset youre data you can use PowerBI Desktop to make it.

You can inject in multiple dataset on multiple data source and combine it with the functionality "Merge queries".

Hope it's help you.

Regards.