Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
iToune
Frequent Visitor

Error when refreshing Dataflow (Microsoft.ACE.OLEDB.12.0')

Hello,

 

I created a dataflow to get data from Sahrepoint folders with many xlsm files.

In order for the xlsm files to work, I had to create a 'template' xlsx file to use as example for the transformation function. It works in the query preview.

 

However, when I try to update the dataflow, I get this error :

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. Request ID: 554a8284-84aa-5a4c-f823-8136b11f2f28 Activity ID: 3bc071f3-103c-4db5-83ca-0b1a60245c07

 

Everything was fully created online, I didn't use PBI Desktop at all.

 

Any idea what to do ?

 

Many thanks

4 REPLIES 4
Anonymous
Not applicable

Hi @iToune ,

This is legacy file type,

Will it be possible to save the file as xlsx, if yes then you are good

If Not, you have to use Power BI Gateway and on Gateway server install Microsoft.ACE.OLEDB.12.0 Provider.

ACE.OLEDB.12.0 provider not registered on local machine | Microsoft Learn

 

If it does not help, please provide more details.

 

Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thanks you for the answer. I'm not sure I get the 'legacy file' part. Is the xlsm no longer supported by microsoft? Why does it work on Power BI Desktop?

Anonymous
Not applicable

Hi @iToune ,

The above SharePoint folder approach only works for XLSX files. The Power BI Desktop and the Power BI service both support both Excel file formats (XLS and XLSX). However, refresh does not. If the source file format is XLS, and a refresh is attempted, you will receive the classic “microsoft.ace.oledb.12.0 provider” error in the Power BI service.

 

More details: Using Excel Files with Power BI Desktop and SharePoint – The White Pages (tygraph.com)

 

I have also found some similar posts, please refer to.

Solved: Need help with error message - Microsoft Power BI Community

Solved: Dataflow error: "Microsoft.ACE.OLEDB.12.0 provider... - Microsoft Power BI Community

 

Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

OK thanks I will look into these.
But my file are XLSM, not XLS (which I understand is an old format).

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.