visuals taking long time to load in direct query mode

[Anonymous]

I have created a live connection between power bi and snowflake in which i am representing credits used by each warehouse and i did so. But the visuals in power bi are taking time to load. I have used a slicer to filter the report by using parameters year,month,day,hour .Whenever i applies a filter visual updation takes long time. Can anyone suggest how should i optimize the speed in direct query mode

[AnkitBI]

Please go through below links. Had lots of useful information on Direct Query limitations and improvements.

https://docs.microsoft.com/en-us/power-bi/desktop-directquery-about

https://docs.microsoft.com/en-us/power-bi/power-bi-reports-performance

Thanks
Ankit Jain

Do Mark it as solution if the response resolved your problem. Do like the response if it seems good and helpful.

[Anonymous]

@AnkitBI  Actually Report is taking average time of 5-6 seconds to load. I just want to know  can i reduce the time below 5 seconds in direct query mode ?

[AnkitBI]

Yes, you can improve performance. Links provided for Direct Query has section "Guidance for using DirectQuery successfully" with lots of perfomance tips.

Try implementing those and check if time is getting reduced.

[Anonymous]

Ok Thanks.