Readers can check out our guide on how to refresh data in Power BI to assist with a manual refresh in Power BI Desktop.

Why is the scheduled refresh option greyed out in Power BI?

Users can encounter Power BI scheduled refresh greyed-out errors because of issues with the Power BI account or installation. Hence, it prompts Power BI processes to run into issues like being greyed out. Likewise, other factors can cause the issue. Some are:

Dataset not connected to data source – The dataset not connected to a data source that supports scheduled refresh can cause the problem. DirectQuery connection does not support scheduled refresh – The issue can occur if the dataset you are trying to refresh depends on a DirectQuery not supported by Scheduled refresh. Dataset does not support scheduled refresh – If the dataset you are trying to refresh is dependent on a live connection to a data source, it may not support Scheduled refresh. Hence, it can result in an issue. Scheduled refresh is disabled on other files – The dataset you try to refresh may rely on an Excel workbook or CSV file stored on OneDrive or SharePoint Online. So, the refresh schedule may be disabled for the file type.

However, these reasons can differ on Power BI accounts on different PC.

How do I enable scheduled refresh in Power BI?

Apply the following preliminary checks:

Fix Network congestion issues. Make sure the dataset is structured correctly.

These will prepare you from encountering errors when following the steps stated below.

1. Make changes from Options and settings

You must have permission to connect to the data source and permission to publish the report to the workspace where you are publishing it. Read about what to do if you don’t have permission to open files in Windows.

2. Create a new schedule refresh plan

Creating a new schedule refresh plan allows you to enable Power BI Schedule Refresh. You can check how to add a report to a dashboard in Power BI for more details on mastering the use of Power BI. You may also discover how to bypass Power BI sign-in issues and the best browsers that support Power BI on all platforms on your PC. If you have any questions or suggestions, kindly drop them in the comments section.

SPONSORED Name * Email * Commenting as . Not you? Save information for future comments
Comment

Δ