Error Help with -2147467259

[CAPEconsulting]

Hi everyone,

Does anyone know why I am getting this error and what the resolution is.

The data is many csv and excel documenys stored in an Azure blob storage folder.

Underlying error code: -2147467259
Underlying error message: The specified package is invalid. The main part is missing.
DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259
Microsoft.Data.Mashup.ValueError.Reason: DataFormat.Error
Cluster URI: WABI-AUSTRALIA-SOUTHEAST-redirect.analysis.windows.net
Activity ID: 7d7eee24-574f-4f56-b151-d439e434de9f
Request ID: 0230bdd0-2ade-8cea-46e2-c19ee2b5c7c5
Time: 2022-08-23 06:34:24Z

[v-yangliu-msft]

Hi  @CAPEconsulting ,

You may refer to the links:

https://community.powerbi.com/t5/Service/Data-Refresh-Error-The-specified-package-is-invalid-The-mai... ,

https://stackoverflow.com/questions/23239029/openxml-spreadsheetdocument-open-get-exception-the-main...,

https://www.codeproject.com/Questions/1139723/The-specified-package-is-invalid-the-main-part-is .

Best Regards,

Liu Yang

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