Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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?
Solved! Go to Solution.
Yes you can
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?
you should go for One by one
User | Count |
---|---|
73 | |
70 | |
38 | |
24 | |
23 |
User | Count |
---|---|
96 | |
94 | |
50 | |
42 | |
40 |