Forum Discussion
Online Direct Query Performance
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
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 .
5 Replies
Is that an on-premise data source? Are gateways involved?
Hi Ibendlin,
there is no gateway involved. The datasource is an Azure SQL Server
