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.
Thank you so much for your help!!!
I tried to follow your instructions: first, I created a new report in Power BI Desktop using the SharePoint folder (step 1 in the screenshot). I did this in Power BI Desktop because I couldn’t find an option to change the "Get Data" source in the already imported file in Power BI Online.
Then (step 2), after selecting the SharePoint folder, I chose the Excel file as shown in step 3.
Once the report was created, I went to Power BI Online and uploaded the file using the SharePoint option (step 4 in the image).
After that, I checked all access settings, credentials, and so on.
Now, not even the manual refresh works anymore — as you can see in step 5 of the screenshot. It keeps trying to refresh for over 10 minutes and never finishes.
Did I do something wrong in the process?
Thanks again for your support!
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.
