cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mmarti92 Frequent Visitor
Frequent Visitor

Connect PoweBI to servers running on a different environment

Hello,

 

I have encountered a problem. My organisation´s IT manager says he is unable to enable a remote connection between PowerBI and an SQL database. 

 

The reason is, aparently, that PowerBI is running on an Azure environment, while the database is running on its own dedicated server. Is this a real issue? And if it is, is there a fix in place?

 

Thank you all in advance!

1 REPLY 1
Moderator v-qiuyu-msft
Moderator

Re: Connect PoweBI to servers running on a different environment

>> PowerBI is running on an Azure environment, while the database is running on its own dedicated server.

 

Do you mean the Power BI service to get data from SQL server database? 

 

If it is, you can download and install on-premises data gateway on a machine which can communicate with SQL Server. Then go to Manage Gateways on Power BI service, to create a SQL data source points to this SQL server, go to dataset settings, configure the dataset uses this gateway. For more information, see: 

 

https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem

https://docs.microsoft.com/en-us/power-bi/service-gateway-enterprise-manage-sql

 

Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.