Forum Discussion
Issue in Dataset Refresh Strict Open XML Spreadsheet (*.xlsx)
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!
1 Reply
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.
