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
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.