Use Multiple data sources on same server

[adave]

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.

[adave]

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

[smodglin]

@adave Did you ever resolve this? I am running into this issue, too. 

[adave]

I ended up creating a view in the database which pulls the data from both sources ( you'll need to a userid that would have ability to query both sources) and using that view in Power BI.