Getting Data from Two or More SQL Server Databases

[tmhalila]

Hello,

Anyone assist

I have a client who needs to verify data between two databases from the Old system vs New System. He just needs visuals to report on Power BI to see the flag of the column which is unmatched.

Now my question is, Is it possible to import Tables from different databases then create a new relationship and run some transformation through a Power Query for comparison?

[Anonymous]

Yes you can

[tmhalila]

How to go through import steps? Assuming I want to connect between these two databases KCC and OVC_General.  Am I supposed to import one by one or write SQL statements to join them at the beginning?

[Anonymous · Accepted solution]

you should go for One by one