Forum Discussion

mike_honey's avatar
mike_honey
Icon for Memorable Member rankMemorable Member
10 years ago

Dataset Refresh error Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine

I built a report using PBI Desktop - the source is an Excel file on a public website (not OneDrive).  When I publish it and then try to use the Power BI site to refresh the dataset, I get this error:...
Anonymous's avatar
Anonymous
Not applicable
4 years ago

I had a different situation. PowerBI data gateway was reading Excel files from on-premises file server share. And suddenly a report datasource schedulled refresh stopped working with the above error.

-2147467259

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.

DataSource.NotFound

 

What we found out, is that a user has opened an Excel file with LibreOffice or OpenOffice Calc, and left a lock file:

.~lock.filename.xlsx#

just beside the XLSX file, that PowerBI data gateway was reading as datasource was refreshing.

Simply deleting this lock file was enough for PowerBI data gateway to successfully continue refreshing the data source. 

  • DouweMeer's avatar
    DouweMeer
    Icon for Impactful Individual rankImpactful Individual
    3 years ago

    I saw an extra file that I deleted, referring to this element:

    Simply deleting this lock file was enough for PowerBI data gateway to successfully continue refreshing the data source. 

    Deleting that "extra" file in my folder solved the issue. Some cryptical name with a blank icon. I couldn't be bothered to check it first before removing, so no further details. I'm happy it runs again. 

    Edit: was a temp file (.tmp)

Related content