topic Re: Performance Improvemnt_Azure Embedded report in Developer

Performance Improvemnt_Azure Embedded report

somoksarkar — Mon, 28 Aug 2017 07:23:37 GMT

Dear all,

We are using a power BI desktop application to develop the reports and the output is embedded in Azure portal. over the last few days we are experiencing enormous amount of time consumption to render the dashboard. The same is happening in the the report section of power BI desktop application as well.

Can someone please guide me if there is a step by step solution available in MS Power Bi to debug this issue and identify exactly which query/modelling is causing this please?

Thanks,

Somok

Re: Performance Improvemnt_Azure Embedded report

Eric_Zhang — Wed, 30 Aug 2017 06:49:35 GMT

@somoksarkar

What is the datasource? Per my experience, if it is connecting to an Azure SQL DB in a directquery mode, to improve the performance, try

Don't use unrestricted measures
Increase the Azure SQL DB performance tier
Use import mode instead.

Re: Performance Improvemnt_Azure Embedded report

mercyeliana — Tue, 06 Mar 2018 20:12:36 GMT

@Eric_Zhang

I am having the same problems, my scenario is:

* Azure SQL DB

* PowerBI uses DirectQuery

* PowerBI is embedded

* Activated the option for DirectQuery: Allow unrestricted measures in DirectQuery mode

* The dataset is just a sample of the real data and the measures are not complicated. There is a topN in 1 table.

* The same performance problem happens even if the conection is a local DB

* We have already increased the azure SQL DB tier

¿Should I create a tabular model in Azure and conect the PowerBI embedded to this tabular? ¿Is tabular model supported in embedded?