power bi refresh for snowflake giving error

[Anonymous]

Hi Team

I am getting data refresh error in import mode in PowerBI service while trying to run the query in Snowflake database

Error: Statement exhausted compilation resources and was canceled. Please contact support.

This error I got in the first attempt of refresh

During second attempt for refresh I received the below error:

Before the data import for finished, its data source timed out. Double-check whether that data source can process import queries, and if it can, try again.

Please help me in resolving this issue

Regards

Arun Hariharan

[v-cazheng-msft]

Hi @Anonymous 

May I know whether you have issue to refresh same report in Power BI Desktop after downloading it from Power BI service? Is your report create with a large data amount from Snowflake? If you remove some unnecessary columns or rows from the model and refresh it, will it be refreshed failure? And there are two options in Snowflake connector can prolong the timeout time, please consider trying it.

Best Regards,

Community Support Team _ Caiyun