Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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?
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
I am facing the same issue and can not still figure out it
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
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?
Up...
Never figured this out neither
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
81 | |
76 | |
61 | |
37 | |
33 |
User | Count |
---|---|
99 | |
56 | |
51 | |
42 | |
40 |