Showing results for 
Search instead for 
Did you mean: 
K_lel Frequent Visitor
Frequent Visitor

web API Range header error



I'm working on a web API with 2 headers : Authorization and Range. the M code below :


API = Json.Document( Web.Contents("",
        [RelativePath="api/1.0/equipments ",
         Headers = [Authorization="Bearer " & token, Range ="elements=0-5"]])


This web API works fine with POSTMAN, but in power query the code return this error about Range Header :


"Expression.Error : 'Range' header must be modified in proprieties or with adequate method.
Parameter name : name
Details :


has anyone an idea why Power Query doesn't like Range hearder ?



Community Support Team
Community Support Team

Re: web API Range header error

hi, @K_lel

It seems that no such question has been raised, I looked through a lot of documents, and do not find about,

You could post at the Issues forum or create a support ticket in Power BI Support to get further help.



Best Regards,



Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
jherynk Frequent Visitor
Frequent Visitor

Re: web API Range header error

Helpful resources

Community Highlights

Community Highlights

Find out what's new in the Power BI Community!

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 327 members 3,082 guests
Please welcome our newest community members: