cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Ghislain
Advocate I
Advocate I

Can we get data from 2 different databases?

Hello PowerBI community !

 

I have an interrogation today, I want to know if we can get data from 2 different databases. For example if i have 2 Sql server database from 2 different companies. Is it possible to create a dataset in Power Bi ?

 

Thanks in advance,

Ghislain

1 ACCEPTED SOLUTION

@Ghislain Provided that you use "Import" - yes, you can source data from multiple SQL Servers with different credentials.


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

View solution in original post

6 REPLIES 6

@Ghislain Provided that you use "Import" - yes, you can source data from multiple SQL Servers with different credentials.


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

View solution in original post

@Seth_C_Bauer But we need 2 different gateway to refresh data in this case, no ?

 

@Ghislain No, As long as you are importing the data, you would just create seperate data sources on the same On Premises Data Gateway for each SQL Server. As long as all the data sources in the PBIX file match to data sources on the same OPD Gateway then it will allow you to use it for refresh.

 


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

@Seth_C_Bauer I see what you mean there is a point i don't understand.

 

For example: 

- I have a database in my server of company 1

- I have another database in another server of company 2

- I create as you say different data sources in OPD Gateway

But where do i install OPD Gateway ?

 

 

@Ghislain In the same domain that is under your tenant.

For example. I belong to company 1, and I access my SQL Databases with Windows Auth.

But I also want data from a 3rd party - Company 2

They have provided me with a SQL Login that I can use to access their instance.

So I create two seperate data sources in my PBIX and in my gateway I've installed on my company 1 server.

 

The OPD Gateway can be installed on any server in your domain. guide here for requirements

You could install it on the same box as the SQL Instance, but if you are expecting a significant amount of load, then you may want to install it on a seperate server/VM.


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

@Seth_C_Bauer Perfect I understood the concept thank you very much !

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

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Top Solution Authors