Automatic Refreshes while connected to SharePoint - Does it really work as explained by Microsoft?

Hi morteza ,

//If you created your datasets and reports based on a Power BI Desktop file, Excel workbook, or comma separated value (.csv) file on OneDrive or SharePoint Online, Power BI performs another type of refresh, known as OneDrive refresh. 

You need to use the above data source to trigger a OneDrive refresh, otherwise this option won't appear in the layout. My test process is as follows:

Suppose we have an excel file with a table in it:

Save in SharePoint.

Connect to excel file in SharePoint:

Create a report, here I simply create a table visual and save it.

Check for OneDrive refresh, enabled by default.

Go back to the data source location to edit the table.

It has been automatically refreshed after about ten minutes after editing.

Check the report, the data inside is up to date.

For your reference.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data