Powerbi embeded report does not work with direct query on premises enterprise gateway

[amurias]

PowerBI embeded report data is not showed when data is thru on premises gateway.

This case was using SSAS cube on SQL2016 azure VM server.

This is the error (spanish version), some id had been masked with xxxxx for privacy

No se puede cargar el esquema para el modelo de la base de datos

No se puede cargar el esquema de modelo asociado a este informe. Asegúrese de disponer de conexión al servidor e inténtelo de nuevo.
Vuelva a intentarlo más tarde o póngase en contacto con el soporte técnico. Proporcione estos detalles si se pone en contacto con ellos.

Identificador de actividad xxxxx

Identificador de la solicitudxxxxx

Id. de correlaciónaxxxxx

HoraTue Jun 13 2017 17:29:00 GMT+0200 (Hora de verano romance)

Versión13.0.1700.2465

URI de clústerhttps://WABI-UK-SOUTH-redirect.analysis.windows.net

[v-haibl-msft]

@amurias

The old PBI Embedded offer (Azure embedded) cannot use a gateway. Please refer to https://docs.microsoft.com/en-us/azure/power-bi-embedded/power-bi-embedded-connect-datasource.

You are using SSAS on-premise and on Azure, but it’s still on premise even on Azure.

Now the new offer can do that. Please refer to https://powerbi.microsoft.com/en-us/documentation/powerbi-developer-embedding/. Power BI Embedded is covering with Power BI Service, thus not longer an Azure service. The current Power BI Embedded service(on azure) will continue to be available for a limited time. You can't see option to create new workspace collection on Azure now. If you have already got Power BI workspace collections on azure, consider migrating them to Power BI Service.

Best Regards,
Herbert

[amurias]

Thanks for the reply

The problem, for this particular case, is that the monthly cost  “entry point” is too high (P1 Node 4200€/month) as we may need around 20 users as starting point.

And we need the progamatic access to PowerBI reports to embed inside an application.

Any other possibility regarding pricing?

[dmitriisolovev]

You should have a look at the EM1 SKU (USD 625/month) or buy Pro license for each user ((20+1)x10 + = USD 210/month)

[amurias]

Hi, we've already power bi PRO licenses, but for the embeded funtionality you need to buy POWER BI SERVICE

[dmitriisolovev]

Not sure what you mean as "Power BI Service". There are 3 main components of the Power BIsuite:: 1. Power BI Desktop free authoring tool. 2. Power BI Service designed to distribute reports/dashboards embed, etc. 3. Power BI Report Server (hosts power bi reports on-premise). 

So, if you already have Pro license it means you have Pro license for Power BI Service and can embed reports/dashboards/tiles. 

[amurias]

Powerbi embeded report that access data thru enterprise Gateway, on a Azure VM using sqlserver SSAS, not working.

Report page shows but with data error message.

translation from Spanish message:

"Cannot load schema for the data base model"

Any data appears in the Visual.

Reports published in powerbi .com (Pro) work perfectly.