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
rajkumarg1991
Frequent Visitor

Scheduled Refresh Failing for Dataset Due to Timeout

I've scheduled my Power BI dashboard to automatically refresh the dataset every day at 12 AM. However, one of my tables, which is created as a view, is consistently experiencing slow refresh times and resulting in an 'Execution Timeout' error. Our organization is currently using Power BI Pro licenses. I would greatly appreciate guidance on identifying and resolving the underlying issues causing the prolonged refresh times for this specific table. Are there any optimization strategies or configurations that can be implemented to address this challenge? Your assistance is invaluable. Thank you!
 

details of the warnings or errors
Screenshot 2023-11-10 091031.png

 



1 REPLY 1
BA_Pete
Super User
Super User

Hi @rajkumarg1991 ,

 

Very difficult to say without seeing the view definition, but a view must be materialised on the server before being readable, so can be more resource-intensive than a natural table.

Additionally, I'd speak to your DBA about when the maintenance windows are for your server. Quite often servers have a window (for example 22:00-03:00 or similar) when they run all their diagnostics/updates/Stored Procs etc., so you want to avoid that time period for running refreshes on it.

 

Pete



Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!




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
Top Kudoed Authors