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

Use Multiple data sources on same server

Hello,

I am somewhat new to PowerBI. I am trying to use multiple data sources located on the same server. There are two separate databases with different credentials. I am using import mode to connect.

So lets say I have DB1  and DB2 is on server P and each has a user DB1_user and DB2_user.

 

Once i connect to DB1 with userid DB1, when i try to create a query for DB2 then the query which i created for DB1 says invalid credentials. It gets updated to the credentials of DB2 database.  I am not sure how to have two data sources with separate crentials in one report. Is this possible? I am using PowerBI report server version March 2018.

2018-07-03_10-15-42.png

1 REPLY 1
adave Frequent Visitor
Frequent Visitor

Re: Use Multiple data sources on same server

I wanted to mention, I am trying to use two SQL Server connections with different userid's