Failed to load 1.40GB JSON over HTTP using WEB connector

[Mateusz]

Hi,

Trying to load pretty big JSON content (1.40GB) over HTTP to Desktop PowerBI using WEB data connector. Unfortunatelly this fails with:

Unable to connect

We encountered an error while trying to connect.

Details: "Received an unexpected EOF or 0 bytes from the transport stream."

Have I ran into some PowerBI limitations? Downloading a file on the same machine takes around 10minutes. Uploading a file directly to PB using JSON connector does not finish within 30m.

Is there any way I can debug what went wrong? In general what is the recommended way to load this types of volumes to PB?

Thanks in advance

--

MK

[v-yulgu-msft]

Hi @Mateusz,

Are you able to connect to the same JSON source from Power BI desktop on a different machine under a different network?

Regards,

Yuliana Gu