Forum Discussion
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 an...
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