cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Candi721 Frequent Visitor
Frequent Visitor

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
1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: How to create two different database connection 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

 


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


1 REPLY 1
Super User
Super User

Re: How to create two different database connection 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

 


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!