Invalid Identifier while configuring my query for refreshing web sources in Power BI service

[shaw1976]

Hello All,

I'm trying to factor my query to allow auto refresh from the power bi service by using the RelativePath. The "Invalid Identifier" error is occuring when I call the function that has the bearer token.

let
Source = 
Json.Document(Web.Contents("https://admin.10ten.com/api/v2/",
[RelativePath="students?",
Query = [
Year="2024",
IsEnrolled="true",
PageSize="500",
Headers=[Authorization= Bearer, bearer()]
]
]
)
),  

The function is called with no issue when I execute the query this way.

Source = Json.Document(Web.Contents("https://admin.10ten.com/api/v2/students?" & "Year=2024&" & "IsEnrolled=true&" & "PageSize=500", [Headers=[Authorization="Bearer " & bearer()]])),

Any guidence is greatly appreciated.

[PwerQueryKees · Accepted solution]

Get rid of the comma, keep the &

That will be syntacticly correct. 

[shaw1976]

Thanks, that did it!

[PwerQueryKees]

Your original that worked said "

Authorization="Bearer " & bearer()

"

Why did you change it to 

Authorization= Bearer, bearer()

 These two are totally different, with the new version violating the M language syntax for a record...m

[shaw1976]

@PwerQueryKees , sorry for taking so long to reply. I was on vacation then handling a few issues that occured during my abscense.

When I include the ampersand I get a 'Invalid identifier' error.

Any advice or guidence you can offer is appreciated very much.

[shaw1976]

Thank you for your reply. I have been on vacation. I will address this by EOD tomorrow and mark as resolved if it solves the issue.

[PhilipTreacy]

@shaw1976 

Try moving the bearer() function out of the Headers e.g.

let
token = bearer(),
Source = 
Json.Document(Web.Contents("https://admin.10ten.com/api/v2/",
[RelativePath="students?",
Query = [
Year="2024",
IsEnrolled="true",
PageSize="500",
Headers=[Authorization= Bearer, token]
]
]
)
),

regards

Phil

[shaw1976]

Thank you for your reply Phil, much appreciated.

I'm sorry, this does not work. I implimented it that way first, I recieve the error "Token '=' expected" on line ten.