Forum Discussion
Scheduled refresh on Snowflake are really slow
Hi all,
We have reports deployed on Power BI service (Pro licence, not Premium workspace) that connect to Snowflake (on AWS, Canada), with queries in import mode only. We use the recent connector withtout the data gateway.
Those reports refresh in a few seconds when I use 'Refresh now' (on demand refresh), but this generally take 12-13 min (sometimes way more than that) with the schedule, even if there is only 1 report refreshing. And what is strange is that queries start to hit snowflake around 10min after the refresh schedule (and then queries are really fast, few seconds).
Do you have any idea why this delay?
Thank you
3 Replies
- Greg_Deckler
Community Champion
Well, refreshes in the Service can be +/- I think up to an hour versus scheduled what is scheduled I believe.
You could check the Issues forum here:
https://community.powerbi.com/t5/Issues/idb-p/Issues
And if it is not there, then you could post it.
If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET". - v-gizhi-msft
Community Support
Hi,
Did the first reply solved your issue?
If so, please mark it as a solution for others to see.
Thanks!
Best Regards,
Giotto
