Forum Discussion
Onedrive automatic update does not work
Hi ricardoCB ,
Thanks so much for the detailed update!
I really appreciate you walking us through the exact steps you followed. Given that manual refresh works but scheduled refresh still doesn’t trigger even with the Web connector and direct SharePoint file URL, it looks like everything on your end has been configured correctly.At this point, the issue likely requires deeper investigation from the Power BI support team.I recommend raising a support ticket so the engineering team can review backend logs and assist further.
To raise a support ticket for Fabric and Power BI, kindly follow the steps outlined in the following guide:
How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn
Hope this helps.If so,consider accepting it as solution.
This is the error message from manual update :
- Data source errorDataSource.NotFound: Excel Workbook: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. The 64-bit version of the Access Database Engine OLEDB provider may be required to read this type of file. To download the client software, visit the following site: https://go.microsoft.com/fwlink/?LinkID=285987.. Microsoft.Data.Mashup.ErrorCode = 10478. . The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action. Table: Query1.
Oh noes ! You are using a .xls or .xlsb file. Don't do that. Use .xlsx or .xlsm
Hello ! It is a xlsx file !!!
thanks