Performance Improvemnt_Azure Embedded report

[somoksarkar]

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

[Eric_Zhang]

@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

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

[mercyeliana]

@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?