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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Error with Open Strict Xml Spreadsheet in Dataflow

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.

Status: Accepted

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

Comments
v-yingjl
Community Support
Status changed to: Accepted

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
Microsoft Employee

Hi @Anonymous. 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.

Anonymous
Not applicable

Hi @Anonymous 

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

Anonymous
Not applicable

@Ehren Thanks for the help.