Joins with different datasources

[Anonymous]

Can we create the joins with tables from different types of data source (SQL / Oracle) all together?

[Anonymous · Accepted solution]

You can use the MERGE functionality. Details and instructions you can be found at the bottom of this page.

[v-qiuyu-msft]

Hi @Anonymous,

Of course, it's able to merge queries from SQL and Oracle databases in Power BI desktop. 

Best Regards,
Qiuyun Yu 

[Anonymous]

Thanks.

It means if I am having two different data sources Oracle (O) and MSSQL (M). Suppose there is a table OT in oracle data source and there is one table MT in MS SQL Database. So, we will be able to create a graph using both tables OT and MT. Is it so? 

[v-qiuyu-msft · Accepted solution]

Hi @Anonymous,

Besides merge queries in Query Editor mentioned by @Anonymous, you can go to Relationship view, create a relationship between these two tables, then in Report view, you can drag desired columns form these two tables to the same visual easily. 

Reference: 

https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships

Best Regards,
Qiuyun Yu 

[Anonymous · Accepted solution]

You can use the MERGE functionality. Details and instructions you can be found at the bottom of this page.