Snowflake query taking too long to load In PQ

[Anonymous]

Hi all,

I just started using Snowflake as a data source in Bi & when I try to load a Snowflake query in PQ its taking an unusal amount of time. the query runs quick in Snowflake but in BI its the opposite. are there any ways to speed this up or hacks to make this better?

Thank you! 

[amitchandak · Accepted solution]

@Anonymous , refer these setting

also check

https://blog.crossjoin.co.uk/2020/05/14/speed-up-data-refresh-performance-in-power-bi-desktop-using-table-view/