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

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

smodglin
Frequent Visitor

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

adave
Frequent Visitor

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
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!