"Unlike a dataset refresh during which Power BI imports data from a data source into a dataset, OneDrive refresh synchronizes datasets and reports with their source files. By default, Power BI checks about every hour if a dataset connected to a file on OneDrive or SharePoint Online requires synchronization."
"OneDrive - Business – If you have OneDrive for Business and you sign into it with the same account you sign into Power BI with, this is by-far the most effective way to keep your work in Excel Power BI Desktop, or a .CSV file and your dataset, reports, and dashboards in Power BI in-sync. Because both Power BI and OneDrive are in the cloud, Power BI connects to your file on OneDrive about every hour. If any changes are found, your dataset, reports, and dashboards are automatically updated in Power BI."
This seems to say that, unlike a scheduled refresh which has to be set up, it will happen automatically. I have uploaded a workbook to OneDrive for Business, connected to it in Power BI Desktop using the weblink, then published to the Service. Now if I edit the workbook and save it, it doesn't automatically update the Dataset (it's been a day or two since). However, if I go to the Dataset page and click on Refresh Now, it works fine.
If I go to the Settings page, it doesn't even show the OneDrive Refresh option, which seems to indicate it doesn't see it as a OneDrive Excel workbook, which it clearly is.
On the other hand, if I set up a Scheduled Refresh (8 times once per hour - max of Power BI Pro licence), it works fine.
Have I misunderstood something? Or do I need to do something different?
'When you store a Power BI Desktop file on OneDrive or SharePoint Online, any data you’ve loaded into your file’s model is imported into the dataset, and any reports you’ve created in the file are loaded into Reports in the Power BI serviced. When you make changes to your file on OneDrive or SharePoint Online, such as adding new measures, changing column names, or editing visualizations, once you save the file those changes will be updated in the Power BI service too, usually within about an hour.'
Thanks for the documentation. Can I confirm the following:
I have used Get Data/OneDrive for Business/Connect to connect the Dataset from OneDrive (in the PBIX file) to the Power BI Service. I have connected that PBIX to an Excel workbook in my OneDrive for Business folder.
If I make a change to the PBIX, I don't have to click on Publish, because it automatically syncs between OneDrive and Power BI Service.
However, if I make a change to the Excel Workbook (the data source), I need to either (a) initiate a manual refresh and/or (b) set up a Scheduled Refresh (up to 8 times daily maximum). It does not automatically refresh the data source like the PBIX sync above.