Forum Discussion

Ghislain's avatar
Ghislain
Advocate I
9 years ago
Solved

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 i...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

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

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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.

Ghislain's avatar
Ghislain
Advocate I
9 years ago

Anonymous Perfect I understood the concept thank you very much !