Power BI dataflow refresh error in Power BI Service

[bajajk]

I am getting the error in refreshing the power BI dataflow in Service. Source for dataflows are excel workbook xlsx stored on sharepoint. Till last week it was working fine.  Some micrsoft 365 installed happened on 27th May and itI think issue is somehow linked with the updates.

Please suggest.

Error: DataSource.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. Request ID: 1f0164f3-3526-44f6-95ed-014b8ce03bdd Activity ID: 10bdd43a-8cec-4992-9516-a6f1a9ee6c90

[bajajk]

Thank you all. Issue is resolved. There was one hidden file which was causing the issue.

[v-yingjl · Accepted solution]

Hi @bajajk ，

As the error message mentioned, you may need to install the 64-bit version of the Access Database Engine when your Power BI Desktop version is also the 64-bit version.

You can find more details about it at this document: The Access Database Engine bit-version 

In addition, this article introduces some other solutions about this issue that you can refer:

Fix Power Bi error microsoft.ace.oledb.12.0 with these solutions 

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[chucksteel]

This should not be marked as the solution to the question. The question is in regards to an error with the Power BI Service, not with Power BI Desktop.