Full Join

[Anonymous]

Hello Everyone,

I wanted to know if it's possible to perform full outer join on two tables belonging to different databases in Power BI using SQl query only.

[Greg_Deckler]

Hmm. That might be possible since you can plug in any SQL code that you want using the Advanced options. But, the database connection stuff might get in the way. 

[Anonymous]

Hi @Greg_Deckler

Thanks for the reply. Below is a screenshot of two tables which belongs from different databases(AD and SFB). Now I need to perform joins on them using SQL query. I can't do merge queries as it won't fulfill my desired action. Any solution to solve this problem?

Thanks and Regards,

Piyush

[Anonymous · Accepted solution]

Hi @Anonymous,

In my opinion, I'd like to suggest you use external methods to link two databases at databse side(e.g. dataview, link server).

After these steps, you can simply use advanced sql query to achieve this requirement.

Reference links:

CREATE EXTERNAL TABLE AS SELECT (Transact-SQL)

Create Linked Servers (SQL Server Database Engine)

Regards,

Xiaoxin Sheng