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:...
dcresp's avatar
dcresp
Icon for Advocate IV rankAdvocate IV
9 years ago

GilbertQ thanks for the idea in principal it sounded good. However, as I expected you still run into the problem that Power BI can not update from a xls file even when it is saved on OneDrive. The error message is the same as mike_honey was getting as shown below. Given that Power BI and OneDrive are both in the cloud it is obviously not possible to run the client software. Vicky_Song any updates or sugested work arounds.

 

 

  
Data source error: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 2010 Access Database Engine OLEDB provider is required to connect to read this type of file. To download the client software, visit the following site: https://go.microsoft.com/fwlink/?LinkID=285987
  • hmokkapati's avatar
    hmokkapati
    Icon for Helper II rankHelper II
    9 years ago

    Hello,

     

    Is there any resolution to this problem?

     

    I have xlsx files on One Drive for Business and accessed these files using Get Data-> Sharepoint folder and still the same problem occurs when i try to refresh through the Power BI Online Service. The same works fine on Power BI desktop though.

     

    Any pointers appreciated.

     

    Thank You,

    Harisha

     

     

  • cnelson's avatar
    cnelson
    Frequent Visitor
    8 years ago

    Bumping this thread. 

     

    Anybody have a resolution for this? I am having the same issue currently.

  • olivierlenard's avatar
    olivierlenard
    Frequent Visitor
    9 years ago

    Hi All,

     

    I do have the same issue. Any news ?

     

    Best regards

     

    Olivier

  • cnelson's avatar
    cnelson
    Frequent Visitor
    8 years ago

    Bumping this thread. 

     

    Anybody have a resolution for this? I am having the same issue currently.

Related content