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 or contact support. If you contact support, please provide these details.
Please try again later or contact support. If you contact support, please provide these details.
Error CodeDMTS_NoGatewayWithAllDatasourcesToBindError
Server xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Correlation xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Database xxxxxxxxxxxxxxxxxx
ConnectionType{FieldValue}
Activity xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Request ID xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
TimeFri Oct 14 2016 14:59:02 GMT-0400 (Eastern Daylight Time)
Version13.0.1700.324
1 Reply
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
