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:...
rdedonat's avatar
rdedonat
Regular Visitor
6 years ago

Hello I have same problem, Power BI in 64 bit, office in 64bit, the excel is xlsb stored on cloud!

 

How it is possible to solve?

  • rdedonat's avatar
    rdedonat
    Regular Visitor
    6 years ago

    I have been installed and issue is not solved

    C:\Users\rdedonat\Downloads>AccessDatabaseEngine.exe /passive

    C:\Users\rdedonat\Downloads>AccessDatabaseEngine_X64 /passive

    I have Power 64 and Office 64 bit

    the excel workbook I am reading are *.xlsb,

     

    after 10 minutes the refresh on web service goes in error because I suppose the number of rows / tuples is reacheing more than one milion ....

     

    • GilbertQ's avatar
      GilbertQ
      Icon for Super User rankSuper User
      6 years ago
      Hi there

      As far as I know *.xlsb is not supported in the Power BI Service.

      Convert it to a *.xlsx and that should solve it.
    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      hi rdedonat, I am facing the save problem by using .xlsb, did you solve this problem? Thanks

Related content