Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. 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")
Proud to be a Super User!
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
145 | |
79 | |
63 | |
52 | |
47 |
User | Count |
---|---|
219 | |
89 | |
76 | |
67 | |
60 |