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:...
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi,

 

I had the same issue and the way that I resolved it was change my file extension from xls to xlsx. The problem just ocurring when I try to refresh dataset on power services.

 

"Power BI supports importing or connecting to workbooks created in Excel 2007 and later. Workbooks must be saved as .xlsx or .xlsm file type and be under 1 GB. Some features described in this article are only available in later versions of Excel."

 

https://community.powerbi.com/t5/Service/Dataset-Refresh-error-Microsoft-ACE-OLEDB-12-0-provider-is-not/td-p/40585

  • OParada1120's avatar
    OParada1120
    Frequent Visitor
    3 years ago

    I have been dealing with this issue for a few days now and as soon as I come across this post...I was able to get the issue resolved by simply updating the file extension from .xls to .xlsx.

    Thank you for this!

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    This worked for my issue, thanks.

  • AreegElTahan's avatar
    AreegElTahan
    New Member
    4 years ago

    Hi Anonymous , what if I can't change the source's extension?

  • HoanNguyen's avatar
    HoanNguyen
    New Member
    3 years ago

    Good help. Thank you so much.

Related content