Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
sanjyot_firke
Frequent Visitor

Power 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 3
aj1973
Community Champion
Community Champion

@sanjyot_firke maybe you need to raise the size of the warehouse in snowflake 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Thanks 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

Indeed, Snowflake admin can do that.

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors