Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
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
User | Count |
---|---|
99 | |
87 | |
81 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |