Anonymous's avatar
Anonymous
Not applicable
4 years ago
Status:
Accepted

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.

Data Modeling

4 Comments

  • v-yingjl's avatar
    v-yingjl
    Icon for Community Support rankCommunity Support
    4 years ago
    Status changed:
    New
    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's avatar
    Ehren
    Icon for Microsoft Employee rankMicrosoft Employee
    4 years ago

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

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

    Ehren Thanks for the help.

Completed Ideas