Forum Discussion
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
Ghislain Provided that you use "Import" - yes, you can source data from multiple SQL Servers with different credentials.
8 Replies
Ghislain Provided that you use "Import" - yes, you can source data from multiple SQL Servers with different credentials.
Anonymous 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.
I wanted to use data from 2 databases on the same server. I was able to do this with a join.
Does that help?
Hi I'm facing another situation whereby I have 2 different SQL servers (by external IT vendors) and I need to install a gateway each in order to access and automatically refresh the data. I have tried to upload such a Power BI to service but there is an error saying "You do not have a gateway installed".
So can i say it's not possible to use 2 gateways? Or is there a workaround to it?
