Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Data Days is here! Join us now for 60+ days of learning, challenges, and connection. Learn more

Reply
Elimey68
Regular Visitor

API GraphQL webContent fails

Dear Community, 
I am trying to query an API with GraphQL endpoints. I can see the data in the POSTMAN

Elimey68_0-1664390951557.png

and this is the results I am seeing:

Elimey68_1-1664390982620.png

 

Now, I have the following in the PowerQuery Advanced Editors, yet, I can't load any result due to the following error:

Elimey68_2-1664391049578.png

Error is as follows:

Elimey68_3-1664391121391.png

Can you please help me with this?

 

2 REPLIES 2
v-chenwuz-msft
Community Support
Community Support

Hi @Elimey68 ,

Maybe something wrong with the red highlight

vchenwuzmsft_0-1664443630930.png

 

You have determined that Content-Type is json, so please use Json.FromValue or json format text. Text.ToBinary will return Binary.

 

Example:

vchenwuzmsft_1-1664443944805.png

Web.Contents - PowerQuery M | Microsoft Learn

 

Best Regards

Community Support Team _ chenwu zhu

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@v-chenwuz-msft 

Thank you or your reply. 
I have tried your suggested version, but it is not working. 
I have checked different sources and solutions like this: 
https://gist.github.com/petrsvihlik/cc34a6cf1882d515139c5b27f37cf99e
they are all using the text.toBinary() function. 

But I still receive the 404 error

Helpful resources

Announcements
Fabric Data Days is here Carousel

Fabric Data Days 2026

Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.

May Power BI Update Carousel

Power BI Monthly Update - May 2026

Check out the May 2026 Power BI update to learn about new features.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.