Forum Discussion
Advocate IIPowerBI Service refresh/update issue with 'Microsoft.ACE.OLEDB.12.0' error
Hey Guys
I've got a dataset that refreshes/updates without any issues on desktop but fails in the service. The datasource is a bunch of excel files in a sharepoint folder.
When refreshing i get this error description:
Data source error: DataSource.NotFound: 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.. Microsoft.Data.Mashup.ErrorCode = 10478. . The exception was raised by the IDbCommand interface.
Cluster URI: WABI-WEST-EUROPE-D-PRIMARY-redirect.analysis.windows.net
Activity ID: 353c61a5-fe26-40d6-a26a-b69e15d9e037
Request ID: 9672bcba-03b3-0fef-0591-ce20fedf3cb1
Time: 2025-12-05 00:12:26Z
I've tried to;
- Renew the Auth2 - no difference
- change excel file formats from .xls to .xlsx - no difference
- tried to use microsofts helper queries to combine all the excel files in one table - no difference
- tried without helper queries to combine files as such: AddWB = Table.AddColumn(KeepCols, "WB", each Excel.Workbook([Content], true, true)),
with no difference.
i'm a bit clueless on what the real issue is and why.
Have anybody had experiences with the same before and what was the issue?
MacJasem If I got you right you said you had to convert the excel file to xlsx. therefore it means you were on another format.
as docs and lbendlin state xls and other formats are not supported (especially with dataflows) and give you that error.
https://learn.microsoft.com/en-us/power-query/connectors/excel#prerequisites
can you try to put on sharepoint a brand new excel XLSX and try again with dataflow (that should run on cloud 99%).
I'm wondering if even convertion (I expect you did save as from excel) keeps some metadata in the file that make it uncompatible with the standard driver.
11 Replies
- lbendlin
Super User
Your data sources include .xls and/or .xlsb files. Those are not suitable for a reliable (and fast) service refresh as they require a legacy driver. Convert the Excel files to .xlsx or .xlsm - these are supported natively.
v-pnaroju-msftCommunity Support
Thankyou, lbendlin and R1k91 for your responses.
Hi MacJasem,
We appreciate your inquiry through the Microsoft Fabric Community Forum.
We would like to inquire whether have you got the chance to check the solutions provided by lbendlin and R1k91 to resolve the issue. We hope the information provided helps to clear the query. Should you have any further queries, kindly feel free to contact the Microsoft Fabric community.
Thank you.
