Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Error with Open Strict Xml Spreadsheet in Dataflow

Submitted by Anonymous on ‎08-30-2022 11:23 PM

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

See more ideas labeled with:
4 Comments (4 New)
Comments
v-yingjl
Community Support
Community Support
‎08-31-2022 07:58 PM
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
Microsoft Employee
‎09-13-2022 03:53 PM

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
‎09-14-2022 06:52 PM

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
‎09-14-2022 06:59 PM

@Ehren Thanks for the help.

Idea Statuses