I have scheduled 8 refreshes in Power BI for a day for 7 dashboards. But i found out that one of the dashboards is not updating its values. That particular dashboard only refreshes if refresh now option is clicked. Also the schedule refresh option is disabled automatically every day.
2 Answers
Just sharing my learning on the same issue. I have just found out through technical support that schedule refresh will turn off automatically after 4 refresh fails. I couldn't find the reason because my schedule was being turned off randomly. So it seems that's the reason. I have few sources connected and every time one is down my refresh fails.
You need to troubleshoot why your one dashboard refresh is failing. Follow the steps recommended here:
- Go to the Power Bi Web Portal and browse to the location of your dashboard.
- Right click on the the three dots and select Manage
- In the left menu select "Scheduled Refresh" tab (see left red circle in image)
- The rightmost column Status will contain any error that was occurred (see right circle from above image).
The documentation on configuring Scheduled Refresh can be a good place to find a solution to the cause of your problems as well as this scheduled refresh troubleshooting guide. Without the error, we can only guess that its an authentication error, problem with data source, gateway, drivers, memory, etc.