cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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

3 REPLIES 3
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

Highlighted
smodglin Visitor
Visitor

Re: Use Multiple data sources on same server

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

adave Frequent Visitor
Frequent Visitor

Re: Use Multiple data sources on same server

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.

Helpful resources

Announcements
New Ranks and Rank Icons in 2020

New Ranks and Rank Icons in 2020

Read the announcement for more information!

New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

November 2019 Community Highlights

November 2019 Community Highlights

Get an overview of the events and great community content from November.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)