Slow performance directquery to Power BI Dataset

Hi mee3uk ,

According to your description, your model is import mode and data comes from csv. But as l know this "direct query" only appears in the direct query model.

You can check the gateway log to determine if there is a significant delay in connecting to the data source.

If the origianl data from .csv is very complicated and more steps to transform, this will consume more CPU and memory resources. And you can adjust performance based on cpu.

Adjust gateway performance based on server CPU | Microsoft Docs

If the method above does not work well, you can try to optimize performance by streaming data.

Monitor and optimize on-premises data gateway performance | Microsoft Docs

The article linked above also mentions that if you look at the gateway log and what some of the parameters mean, it can help you understand what your problem is.

The same, Optimization your data model maybe a good choice.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.