Forum Discussion

JSR's avatar
JSR
Icon for Helper II rankHelper II
6 years ago
Solved

When getting data from PowerAutomate Flow: DataFormat.Error: We reached the end of the buffer

Hi,

I get DataFormat.Error: We reached the end of the buffer. 

When trying to do same as this example. https://janbakker.tech/use-graph-api-data-in-power-bi-using-logicapps 

(Create a Power Auromate flow to query Microsoft Grahp and get the response in Power BI)

I've tested it with diffrenet APi calls, and same throw same error.

 

Any help on this please?

 

The Power Automate flow runs ok and I can see the response.

 

let
url = "",
body = "{}",
Parsed_JSON = Json.Document(body),
BuildQueryString = Uri.BuildQueryString(Parsed_JSON),
Source = Json.Document(Web.Contents(url,[Headers = [#"Content-Type"="application/json"], Content = Text.ToBinary(BuildQueryString) ] ))
in
Source

 

 

  • Hi @JSR ,

     

    Sorry for asking this but looking at the blog post you need to past your URL on the code and you present (here on the forum) a code without URL:

     

    MFelix_1-1596553779566.png

     

    The blog example

     

    MFelix_2-1596553803226.png

    I don't have any way to text this out but just making some questions that may help or not, do you have your logic app endpoint URL?

2 Replies

  • Hi @JSR ,

     

    Sorry for asking this but looking at the blog post you need to past your URL on the code and you present (here on the forum) a code without URL:

     

    MFelix_1-1596553779566.png

     

    The blog example

     

    MFelix_2-1596553803226.png

    I don't have any way to text this out but just making some questions that may help or not, do you have your logic app endpoint URL?