Online Direct Query Performance

[GJA]

Hi,

I created a dataset plugged on a database with an hybrid mode (Import and Direct Query for last month).

I created some matrix a hierachical organisation and with simple measures. When I a am on power BI desktop the calculation of the matrix are really fast (usually less than 1 sec). But when the report is online, results are extremly slow (between 10 and 20 sec).

Do you know why ? And do you know how I can improve performances ?

Many thanks

[GJA]

Hi Ibendlin,

there is no gateway involved. The datasource is an Azure SQL Server

[lbendlin]

Maybe there's something wrong with the routing between the Power BI service and your Azure SQL instance. Are they in different geographies?

[GJA]

Hi Ibendlin, 

they are in the same Region (Europe)

[lbendlin · Accepted solution]

If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .

[lbendlin]

Is that an on-premise data source?  Are gateways involved?