Forum Discussion

iToune's avatar
iToune
Frequent Visitor
3 years ago

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 transf...
Need Help
iToune's avatar
iToune
Frequent Visitor
3 years ago

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

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.

  • iToune's avatar
    iToune
    Frequent Visitor
    3 years ago

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