Connecting PowerBI Embedded to SQL Server

[pvila89]

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.

[mpo]

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?

[Sunkari · Accepted solution]

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