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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! 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
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.