topic Re: Connecting PowerBI Embedded to SQL Server in Developer

Connecting PowerBI Embedded to SQL Server

pvila89 — Tue, 08 Nov 2016 07:57:17 GMT

Hi,

I am having problems when I try to get data from an SQL server using Power BI embedded.

The scenario is the following:

I have implemented a MVC application that integrates PowerBI embedded. It works when I am getting data from a SQL Azure, but is not working when the data comes from a SQL Server. The error given is the following:

"Your data gateway (Power BI – personal) is offline, but a data gateway is available."

Is there any way to make it work?

Thanks in advance.

Re: Connecting PowerBI Embedded to SQL Server

mpo — Tue, 08 Nov 2016 11:44:43 GMT

I think PowerBI Embedded requires an on-premises gateway to be set up in order to connect to your own data source. Are you using that?

Re: Connecting PowerBI Embedded to SQL Server

Sunkari — Tue, 08 Nov 2016 15:07:14 GMT

There is not gateway support for on-premise sql server database using PowerBi Embedded.

Power BI Embedded only support azure databases with direct connection and direct connection/scheduled refresh will not be supported for on-premises databases using gateway