Document intelligence has a problem to read the xlsx files.

Question

Document intelligence has a problem to read the xlsx files.

Teetat Karuhawanit 0

When I uploaded the xlsx file inside the document intelligence , the error shows like this.

InternalServerError

An unexpected error occurred. Please submit support request with apim-request-id shown below to get further assistance. apim-request-id: a70ccad0-5c43-40e0-9105-38ed87bdbf73

Some of my xlsx files are work fine but some of them are shown the error above. Do you know what is the problem of my file?

Azar 29,520 Reputation points MVP Volunteer Moderator

2024-04-03T11:40:35.1733333+00:00
Hi there Teetat Karuhawanit

Thanks for using QandA platform.

I guess this is an ongoing issue and team is working on a fix, in the mean while can you try these

perform a compose on the source account, if all models are available.

Copy the model to the target account using the same/original modelId from the source account.

reference - https://learn.microsoft.com/en-us/answers/questions/1279842/internalservererror-an-unexpected-error-occurred-p

lemme get back to you on this with an update.
VasaviLankipalle-MSFT 18,676 Reputation points Moderator

2024-04-03T23:55:21.4966667+00:00

Hello @Teetat Karuhawanit , Thanks for using Microsoft Q&A Platform.

Is it possible to share the prebuilt model details, it's API version and the Azure resource region details with us?
Azar 29,520 Reputation points MVP Volunteer Moderator

2024-04-05T13:03:08.99+00:00

Hi there

Checking if this helped, kindly accept the answer if it did thanks much.

2 answers

Your answer

Azar 29,520 Reputation points MVP Volunteer Moderator

2024-04-03T11:40:35.1733333+00:00

Hi there Teetat Karuhawanit

Thanks for using QandA platform.

I guess this is an ongoing issue and team is working on a fix, in the mean while can you try these

perform a compose on the source account, if all models are available.

Copy the model to the target account using the same/original modelId from the source account.

reference - https://learn.microsoft.com/en-us/answers/questions/1279842/internalservererror-an-unexpected-error-occurred-p

lemme get back to you on this with an update.
VasaviLankipalle-MSFT 18,676 Reputation points Moderator

2024-04-03T23:55:21.4966667+00:00

Hello @Teetat Karuhawanit , Thanks for using Microsoft Q&A Platform.

Is it possible to share the prebuilt model details, it's API version and the Azure resource region details with us?
Azar 29,520 Reputation points MVP Volunteer Moderator

2024-04-05T13:03:08.99+00:00

Hi there

Checking if this helped, kindly accept the answer if it did thanks much.

Answer 1

VasaviLankipalle-MSFT 18,676 Moderator

Hello @Teetat Karuhawanit , Thanks for your time and patience throughout this issue.

This error is due to the content size of the Excel file is exceeding the limit set by the service.

To manage file size in Excel, begin by checking the content size, as it varies with different files. Consider reducing the data volume if necessary. If the file remains too large, try to divide the Excel file into smaller ones.

The product team is working on improving the error message. Sorry for the inconveniences that has caused.

I hope this helps.

Regards,

Vasavi

Please remember to "Accept Answer" if any answer/reply helped, so that others in the community facing similar issues can easily find the solution.

Jakub Bober 0

Hi @VasaviLankipalle-MSFT , has this message actually been updated yet? I am still getting a very vague message for large excel files:

(InvalidRequest) Invalid request.
Code: InvalidRequest
Message: Invalid request.
Exception Details:      (UnsupportedContent) Content is not supported: The input content is corrupted or format is invalid.
        Code: UnsupportedContent
        Message: Content is not supported: The input content is corrupted or format is invalid.
        Target: 0

Answer 2

Hello Teetat Karuhawanit,

Welcome to the Microsoft Q&A and thank you for posting your questions here.

Reading through all the issues, try to do the following steps and use the links for your review and clarification:

Step 1:

Ensure the .xlsx file is under 50 MB and not exceeding 500 pages or tables.
Remove complex sheets, hidden cells, macros, charts.
Open in Excel and “Save As” a clean copy to remove hidden metadata.
https://learn.microsoft.com/en-us/azure/ai-services/document-intelligence/overview#limits

Step 2:

Use a ZIP tool to inspect .xlsx (since it’s a ZIP archive):

unzip yourfile.xlsx

If extraction fails or content in /xl/ folder is malformed, the file is likely corrupted.

Step 3:

Use REST API or SDK to test the file with enhanced logging to capture:
- HTTP status
- Content-type headers
- Raw API response
- https://learn.microsoft.com/en-us/rest/api/documentintelligence/

Step 4:

Instead of prebuilt-document, use the layout model, which supports more generalized structures:

  POST https://<your-resource-name>.cognitiveservices.azure.com/formrecognizer/documentModels/prebuilt-layout:analyze?api-version=2023-07-31

https://learn.microsoft.com/en-us/azure/ai-services/document-intelligence/concept-layout

Step 5:

If consistent issues remain, file a support ticket or use Priority Customer Support:

I hope this is helpful! Do not hesitate to let me know if you have any other questions or clarifications.

Please don't forget to close up the thread here by upvoting and accept it as an answer if it is helpful.

Share via

Document intelligence has a problem to read the xlsx files.

2 answers

Your answer