Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
dilip_powebi
Frequent Visitor

Power BI visualization very slow with snowflake direct query

Hi
We have created 1 matrix visualization , which have 4 measures ,using direct query with snowflake , only reading 5 column of table from snowflake .
But its take around 2 minute to load in BI desktop and around 5 minute on BI service and mobile .

i have checked snowflake query history , none of the query take more then 100 millisecond .

i have enabled parallel table loading , and also maximum connection par data source 1000 .
but i can still see snowflake getting every query in 2,3 second interval .

 

dilip_powebi_0-1648035290674.png

 

dilip_powebi_1-1648035315762.png

 

and also so many query come in snowflake with this type of query -
00:00:00.0000000','YYYY-MM-DD HH24:MI:SS.FF9'))) and ("REGION" in (?, ?, ?, ?, ?, ?, ?, ?, ?))
) as "ITBL"
group b

which offcourse going to fail in snowflake .
Please help or suggest what we can do to make this report faster .

1 ACCEPTED SOLUTION
v-zhangti
Community Support
Community Support

Hi, @dilip_powebi 

 

Regarding the slow loading of visualizations, we can optimize them from the following perspectives.
1. First determine whether it is due to reasons other than report design, such as:
    Network problem
    Whether more than one person is viewing the report at the same time
    Whether it is a problem with the PBI Service server (this is mainly checked on support.powerbi.com or verified with the surrounding users)

 

2. Then determine which part of the report itself is the problem, such as:
   Too many visuals on the report page
   Complex calculation logic, such as measure, calculated column, RLS
   DQ/LC mode.
   The distance between data source, gateway and PBI service server is long (Gateway delay)
   Slow response from data source
   Query calculation is complicated

 

The following is the flow chart given in the official documentation, you can refer to the following.

vzhangti_0-1648446249893.png

 

Here are the relevant documents to help you.

https://docs.microsoft.com/power-bi/guidance/report-performance-troubleshoot 

https://docs.microsoft.com/power-bi/enterprise/service-premium-capacity-optimize 

 

Best Regards,

Community Support Team _Charlotte

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

 

View solution in original post

1 REPLY 1
v-zhangti
Community Support
Community Support

Hi, @dilip_powebi 

 

Regarding the slow loading of visualizations, we can optimize them from the following perspectives.
1. First determine whether it is due to reasons other than report design, such as:
    Network problem
    Whether more than one person is viewing the report at the same time
    Whether it is a problem with the PBI Service server (this is mainly checked on support.powerbi.com or verified with the surrounding users)

 

2. Then determine which part of the report itself is the problem, such as:
   Too many visuals on the report page
   Complex calculation logic, such as measure, calculated column, RLS
   DQ/LC mode.
   The distance between data source, gateway and PBI service server is long (Gateway delay)
   Slow response from data source
   Query calculation is complicated

 

The following is the flow chart given in the official documentation, you can refer to the following.

vzhangti_0-1648446249893.png

 

Here are the relevant documents to help you.

https://docs.microsoft.com/power-bi/guidance/report-performance-troubleshoot 

https://docs.microsoft.com/power-bi/enterprise/service-premium-capacity-optimize 

 

Best Regards,

Community Support Team _Charlotte

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

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.