Forum Discussion
How to retrieve custom response headers from a URL using Web Headers
I'm trying to make a call to a REST API that returns the total count of rows in a header X-Total-Count.
However when making a call through Power BI, the Web.Headers only retrieves generic response headers like Content-Type, Server etc.
How can I specify the call or maybe an alternate way to retreive the custom response header X-Total-Count?
8 Replies
These might be able to pull the information you need.
Table.FromColumns({Lines.FromBinary(Web.Contents("url"), null, null, 65001)})= Web.BrowserContents("url")These only return the "body". I'm interested in a "header" (custom response header called X-Total-Count)
Did you ever figure this out?
Hi pranaysharmaman ,
The supported parameters are of the following types.
let searchText = "Power Query" in Web.Headers( "https://www.bing.com", [ RelativePath = "search", Query = [q = searchText] ] )related document link:
Web.Headers - PowerQuery M | Microsoft Docs
If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.This also has the same limitation.
The headers returned are only generic ones.
Power BI only returns following headers -
Postman returns -
Majority of headers are missing from Power BI
The headers available through Power Query are a small subset of what comes back. Unfortunately, Power Query filters out the rest. The only way to get them is to write a custom connector.
Upvote suggestion to get all headers back here: https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=e47d7520-1509-ed11-b5cf-281878de6c19
