Forum Discussion
Advocate IIPowerBI Service refresh/update issue with 'Microsoft.ACE.OLEDB.12.0' error
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.
Super UserMacJasem 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.
Advocate IIHi R1k91
You are right. I also thought that it might be because the excel files where corrupted when copnverted from xls to xlsx, so i investigated it and turns out that was exactly the case. I corrected the corrupted files and saved them in .xlsx format and it worked 👍🙂👌
thanks for all your help!