DataFormat.Error: We reached the end of the buffer

[Fossa]

I'm getting this error in all of my queries: DataFormat.Error: We reached the end of the buffer.

All of my queries look like this:

let
    Source = Json.Document
    (
        Web.Contents
        (
            "https://www.example.com",
            [
                Timeout=#duration(0, 0, 30, 0),
                Headers=[Authorization="Basic base64encodedstring"]
            ]
        )
    )
in
    Source

The base64encodedstring was name:key before being encoded, where the name is the api key name, and key is the api access token.

I'm connecting to the logiforms api. My connection settings are anonymous for all of the urls since the web api option wasn't working properly.

The queries I tried worked for a few of the urls I was using, but once i tried it on a url that contained a lot of data (20,000+ forms with many fields) it stopped working, even if I started a new project and used a url that was working just fine earlier.

I tried resetting my computer as well.

I looked up this problem but didn't find any real solutions.

[v-sihou-msft]

@Fossa

If your API has no limitation on retrieving data, please capture the Fiddler Trace for more detail information.

Regards,

[mvince]

Hi, sometimes we experience the same error when scheduled refreshing. If I try to manualy refresh the dataset it succeeds in few tries