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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

Web.Contents return application/octet-stream instead of application/json with 403



I have written an M function that sends a post request to a API. I want to implement some error handling

when sending an incorrect parameter. When I do that the API should return a 403 status code

but for some reason the response that is returned from" Web.Contents()" is of the type "application/octet-stream" with a response that is "null", when it should be a JSON response with a 403 status code. 



headers = [#"Content-Type" = "application/json", #"Accept" = "application/json"],
response = Web.Contents(url, [
            Headers = headers,
            Content = postData


In Postman, Python, Curl etc. it works fine and the API returns the expected json package with the 403 error.

This is the meta data which is returned:



I can catch the null response but that is not a nice solution. The proper 403 code should be handled. 
Has anybody else experienced this? 




New Member

Hey. I have same problem. Do you resolve it? Please let me know if you done it.

Resident Rockstar
Resident Rockstar

Hi @storm-nhaab - you could consider using the Web.Headers - PowerQuery M | Microsoft Learn function to grab the header only.   Here a recent Blog about the feature.  New Web.Headers M function | Microsoft Power Query

Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors