topic Re: Power BI Embedded using On Premise Gateway Sql Server data source in Developer

Power BI Embedded using On Premise Gateway Sql Server data source

rbmanian75 — Fri, 22 Jul 2016 10:25:41 GMT

Hi,

We have installed the on premise gateway and added our sql server to gateway data sources. and the test connection is working well.

how can we set the report to use on premise gateway sql server data source in the power bi dekstop designer.

We are trying the power BI embedded reports with On Premise Gateway Sql Server Data Source.

To use on premise gateway with power bi embedded do we need a Power BI Pro License?

Thanks

Re: Power BI Embedded using On Premise Gateway Sql Server data source

checo3131 — Wed, 02 Nov 2016 19:23:47 GMT

Did youo find a solution for this scenario? I´m facing the same issue, it seems that PowerBI embedded only works with DirectQuery which only works with SQL Databse online aka Azure database (OnCloud)

Re: Power BI Embedded using On Premise Gateway Sql Server data source

rbmanian75 — Wed, 02 Nov 2016 21:08:46 GMT

No i did not find any solution. we are just using the azure database at present. It is in the to do list of power bi team.

Thanks

Re: Power BI Embedded using On Premise Gateway Sql Server data source

Sunkari — Fri, 04 Nov 2016 07:08:42 GMT

Currently,Power BI Embedded doesn't support direct query/scheduled refresh for on-premise databases