Forum Discussion
Does Embedded Power BI support Enterprise Gateway connection to On-Prem SQL database.?
Hi, I'm getting the following error: Couldn't load the data for this visual Your data gateway (Power BI – personal) is offline, but a data gateway is available. Please try again later o...
Hi luisb,
Currently, enterprise gateway connection to on-premises SQL Server database is not supported with Power BI embedded. Regarding to this issue, you can vote it in this existing idea: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13439685-support-other-data-sources-direct-query-using-gate .
In your scenario, as a workaround, you can migrate data from on-premises SQL Server database to Azure SQL database, then work with Power BI embedded.
There is also a similar thread for your reference.
https://community.powerbi.com/t5/Developer/PowerBI-Embedded-problem-with-Enterprise-Gateway/td-p/37203
Thanks,
Lydia Zhang