Scheduled Refresh Failing for Dataset Due to Timeout

[rajkumarg1991]

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

[BA_Pete]

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