Forum Discussion
Power BI - Snowflake Direct Query Too Slow
Hi, I am using the Direct Query Mode with the SnowFlake connector to query a 650M rows & 50 Columns database. I am getteing serious performance issues to load visuals on Power Bi, with a Matr...
JOSEPIVIDAL , Avoid bidirectional joins. Keep only required visual on the page
refer to these Guidelines: https://docs.microsoft.com/en-us/power-bi/guidance/directquery-model-guidance
refer :https://www.thebiccountant.com/speedperformance-aspects/
Thanks for your help amitchandak but I am trying to find out why is Snowflake getting those queries' start time with that sequence of 2/3 queries per second, that seems to be the reason for making all the process so slow as snowflake itself seems to process the data very quickly.