cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sanketb Frequent Visitor
Frequent Visitor

visuals taking long time to load in direct query mode

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

4 REPLIES 4
Super User I
Super User I

Re: visuals taking long time to load in direct query mode

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.

sanketb Frequent Visitor
Frequent Visitor

Re: visuals taking long time to load in direct query mode

@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 ?

Super User I
Super User I

Re: visuals taking long time to load in direct query mode

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.
sanketb Frequent Visitor
Frequent Visitor

Re: visuals taking long time to load in direct query mode

Ok Thanks.

Helpful resources

Announcements
Coming Soon: T-Shirt Design Contest

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors