Error with Open Strict Xml Spreadsheet in Dataflow

[Ayna]

I have a data source in the format of Open Strict Xml Spreadsheet which is very similar to an Excel file and ends with .xlsx. When I import this file on Power BI Desktop, it just opens like Excel. However, when I deal with it in Dataflow, there pops an error -"DataFormat.Error: The specified package is invalid. The main part is missing." As it works in PBD, it should also work in Dataflow.

[v-yingjl]

Have submited this issue internal to confirm(ICM: 331902208), would update here as soon as possible if there is any progress about it.

Best Regards,
Community Support Team _ Yingjie Li

[Ehren]

Hi @Ayna. It turns out that Strict Open XML spreadsheets require the ACE driver, which means they can only be refreshed via a gateway. I've added some documentation about this to the Excel connector page.

[v-yetao1-msft]

Hi @Ayna 

As @Ehren said , Strict Open XML files require the ACE driver. You should have an existing TSG for missing ACE driver issues . 

Best Regards,
Community Support Team _ Ailsa Tao

[Ayna]

@Ehren Thanks for the help.