Forum Discussion
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 .
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 .
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 complicatedThe following is the flow chart given in the official documentation, you can refer to the following.
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.
1 Reply
v-zhangtiCommunity 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 complicatedThe following is the flow chart given in the official documentation, you can refer to the following.
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.