Does Embedded Power BI support Enterprise Gateway connection to On-Prem SQL database.?

[luisb]

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.

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

Cluster URIhttps://wabi-us-east2-redirect.analysis.windows.net/

[v-yuezhe-msft]

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-sourc... .

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/372...


Thanks,
Lydia Zhang