Forum Discussion
Semail
4 months agoRegular Visitor
Power BI Service: DirectQuery (Kusto) visuals fail online but work fine in Desktop
Hi everyone, I’m facing an issue with a Power BI FinOps dashboard using DirectQuery to Azure Data Explorer (Kusto). The report works perfectly in Power BI Desktop Dataset refresh in the Servic...
- 4 months ago
Hi Semail,
Thank you for the detailed response. Here the issue is related to the DirectQuery in the service because of the strict resource and concurrency limits compared to desktop. Since each visual sends its own query, multiple complex visuals running in parallel can exceed those limits and error occurs.
Since kusto changes are limited in your case, please try the below steps on the power bi side:
- Reduce the number of visuals per page to limit parallel queries
- Simplify DAX measures to avoid complex query translation
- Avoid high cardinality slicers and heavy cross filtering
- If possible, consider a hybrid model like Import with DirectQuery to reduce the load
Thanks and regards,
Anjan Kumar Chippa
mh2587
4 months agoSuper User
You need pre aggregation of the data or increase the queryexecute time