web API Range header error

[Anonymous]

Hi,

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

API = Json.Document( Web.Contents("https://apixxxxxxxx.com",
        [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 :
elements=0-5"

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

thanks

[jherynk]

I've outlined the solution in the article below.  Basically, you'll need to build a Logic App to handle the Range parameter.

https://community.powerbi.com/t5/Power-Query/HTTP-Request-Header-quot-Range-quot/m-p/692931/thread-i...

[jherynk]

@Anonymous I'm also experiencing this problem as referenced here: https://community.powerbi.com/t5/Integrations-with-Files-and/HTTP-Request-Header-quot-Range-quot/m-p/693857#M23316

[v-lili6-msft]

hi, @Anonymous

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,
Lin