Forum Discussion
Helper IIPower BI Autoe Refresh taking a very long time
Hi There,
We have few scheduled reports on power bi server and they are taking more than anhour to refresh. If I do a manual refresh on desktop, it takes around 5-10 minutes, but on the server it is taking long time.
The data sources for these reports are power bi dataflow(which gets data from excel snd snowflake tables). The snowflake table size is more than 1.5 GB. One of the excel sources has more than 800,000 thousand records (The table does not get loaded into the report. Enable Load has been disabled)
How can I see where the performance is getting hampered and optimis the performance for the reports?
Regards,
Sanjyot
3 Replies
- aj1973
Community Champion
sanjyot_firke maybe you need to raise the size of the warehouse in snowflake
sanjyot_firkeThanks for the reply aj973.
How do I raise the warehouse size? This is something that we do not control, but it is maintained by other team.
Regards
- aj1973
Indeed, Snowflake admin can do that.
