Power Bi Unexpected EOF

Preflight Checklist

• I have installed the latest version of Power Query SDK.
• I have checked existing resources, including the common issues and the release notes.
• I have searched for similar issues.

Power Query SDK

0.4.0

Regression From

No response

Platform

Windows

Architecture

x64

OS Version

No response

VSCode version

1.89.1

PQSdkTool Path

No response

Bug Description

In my custom connector I have implemented a function which returns a large amount of data by using the list.generate function in order to make a series of web requests to get paginated data from a web service. The list of tables of records is then combined into a single table. The issue is that I sometimes encounter the error in the screenshot below when loading the data. However, the web service that furnishes the data does not report any errors. It seems as though power bi is getting incomplete data somehow or is closing it's connection for some reason. From the perspective of the web service, it gets a series of requests for some of the pages of data and then simply stops receiving requests after the error is encountered in power bi. I will also add that the data is not changing between attempts that succeed and those that fail.

The code in question is here:

Steps to Reproduce

Open the connector in power bi desktop.
Load a table that utilizes the function to get paginated data.
Wait for data to load or fail (the failure is not always consistent).

Actual Experience

Expected Experience

Sometimes all the data loads from all the pages and everything works as expected.

Additional Context

These "Microsoft.Mashup.Container" logs which show the issue from the screenshot.
PowerBI with EOF error.zip

The issue names no repository file or test. Start by examining the attached Microsoft.Mashup.Container logs and reproducing the intermittent failure in Power BI Desktop with the paginated custom connector; compare successful and failed runs. Done means the source of the unexpected EOF is identified and a verified fix or actionable diagnosis is documented.