Forum Discussion
How to create two different database connection in power bi
I need to create 2 different database connection to pull data so need to figure out how we can do it in power bi. I am trying to find out how to run a query joining tables from different databases after connection is established in power bi
So, you can do this via a Merge query or you could use SQL (Advanced) or you could do it in a single query in Power Query:
https://social.technet.microsoft.com/wiki/contents/articles/32915.power-bi-merge-query-with-m.aspx
1 Reply
So, you can do this via a Merge query or you could use SQL (Advanced) or you could do it in a single query in Power Query:
https://social.technet.microsoft.com/wiki/contents/articles/32915.power-bi-merge-query-with-m.aspx