Issue in Dataset Refresh Strict Open XML Spreadsheet (*.xlsx)

[MNLGAITARJ]

Good day,

Has anyone here tried to connect the data with a format Strict Open XML Spreadsheet (*.xlsx)? Currently i was able to connect the with this kind of format. but my problem now is when i tried to publish and do a schedule refresh on it. There was an error appeared.

Data source error:

[ValidateMarkupTags][ccon]DataFormat.Error: [ccon]The specified package is invalid. The main part is missing.[/ccon]. [/ccon]. The exception was raised by the IDbCommand interface. Table: Table Name

Hope someone can help me to resolve this one.

Thank you!

[Anonymous]

Hi @MNLGAITARJ ,

The problem for you was source file was saved as 'Strict Open XML Spreadsheet' format, not 'Excel Workbook' format. 

You may refer to the links:

Data Refresh Error: The specified package is inval... - Microsoft Fabric Community

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.