Forum Discussion
Unable to schedule auto refresh
Hi ib87 ,
It looks like the refresh option is disabled because the Excel file in your dataset isn’t stored in a location that the Power BI service can directly access for scheduled refresh. To enable it, the file should be placed in OneDrive for Business or SharePoint Online (or in a Teams files location, which is backed by SharePoint). This way, the service can connect to it in the cloud without needing a personal gateway. Also, please check that you have at least Viewer access to the workspace where the Dataflow is located, and make sure the data source credentials are set up under Settings > Data source credentials. Once the file is in a supported location and permissions are in place, the refresh schedule option should be available.
You can refer to Microsoft’s guidance here:https://learn.microsoft.com/en-gb/power-bi/connect-data/refresh-scheduled-refresh
Thank you.
Hi ib87 ,
I wanted to follow up and see if you had a chance to review the information shared. If you have any further questions or need additional assistance, feel free to reach out.
Thank you.
Yes, it looks like the location of my excel file was causing the problem. Once I placed it in Teams folder and uploaded into PowerBI I was able to schedule refresh. Thank you very much for your advice and apologise for my late reply, I've been away for last two weeks