topic Re: Use Multiple data sources on same server in Report Server

Use Multiple data sources on same server

adave — Tue, 03 Jul 2018 17:20:58 GMT

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.

Re: Use Multiple data sources on same server

adave — Thu, 05 Jul 2018 19:45:51 GMT

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

Re: Use Multiple data sources on same server

smodglin — Tue, 03 Dec 2019 01:30:59 GMT

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

Re: Use Multiple data sources on same server

adave — Tue, 03 Dec 2019 14:06:06 GMT

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.