Forum Discussion

mattkocak's avatar
mattkocak
Icon for Kudo Kingpin rankKudo Kingpin
4 years ago

Slow DAX in Event Hub

Hey all,

 

I apologize for the for the vague question. I'm working with a data engineer on a project and I'm coming at this with limited knowledge of the backend.

 

We are using Azure Event Hub to stream data in Power BI. The data roughly follows this path, Azure Event Hub > Streaming dataflow > Dataset > Power BI. The problem is that any DAX query run in Power BI (or directly in the model) has very bad performance.

 

It doesn't seem to be a problem with the DAX itself. The same DAX run with an Azure Analysis Services connection on a similar number of rows runs fine. But when it's run with an Event Hub connection, the performance drops considerably (~3 sec vs >1 min). Visuals loaded without DAX involved seem to have decent performance.

 

Has anyone experienced anything similar with an Event Hub connection? Is there any advice on ways to address the DAX performance issues with this connection?

 

Thanks,

Matt