Forum Discussion

joannab's avatar
joannab
Icon for Advocate I rankAdvocate I
7 years ago

Power BI online refresh - 'Microsoft.ACE.OLEDB.12.0' error

Hello.   I'm getting this error when trying to refresh Power BI dataset online (scheduled and manual refresh):   Excel Workbook: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the l...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

joannab  

I am having the same issue. 

 

v-frfei-msft ,

Has this been resolved?

joannab's avatar
joannab
Icon for Advocate I rankAdvocate I
7 years ago

Hello,

 

it hasn't been resolved on my side. I noticed the cause in this particular case is the source file format - I use .xlsb file. When I save it as .xlsm or .xlsx it's working good, but it's not the satisfying solution for me. 

 

I also have the same issue in another project when using .xls or .accdb source files. Everything is refreshing with no issues on desktop (Access Database Engine installed) but refresh online returns this error.

 

Please let me know if you find any news on that.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    I am compiling 70+ '.xlsx' files and I am unable to refresh online, but no issues on desktop. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      v-frfei-msft ,

      Attaching artifacts supporting that it's coming from an 'On-Demand' web refresh, and not the desktop. 

       

  • Oscar_Mtz_V's avatar
    Oscar_Mtz_V
    Icon for Kudo Commander rankKudo Commander
    6 years ago

    For the access file, what we have done, is saving the file in a local server, and then connecting to it thorugh a Gateway, this works.

    • wilson_smyth's avatar
      wilson_smyth
      Icon for Post Patron rankPost Patron
      6 years ago

      I have an excel file data source with the .xlsx extension, saved in sharepoint online.

      When i do the refresh from my pc it works.

      When i do the refresh from powerbi service i get the Ace OLEDB error.

       

      I can confirm the file is .xlsx, and was always connected to from sharepoint only.


      Any ideas on what might be causing this?

      Thanks