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 Provided that you use "Import" - yes, you can source data from multiple SQL Servers with different credentials.

  • Ghislain's avatar
    Ghislain
    Advocate I
    9 years ago

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

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      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.

       

      • Ghislain's avatar
        Ghislain
        Advocate I
        9 years ago

        Anonymous 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 ?