Forum Discussion

shaw1976's avatar
shaw1976
Frequent Visitor
2 years ago
Solved

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

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 th...
Need Help
  • PwerQueryKees's avatar
    PwerQueryKees
    2 years ago

    Get rid of the comma, keep the &

    That will be syntacticly correct. 

PhilipTreacy's avatar
PhilipTreacy
Super User
2 years ago

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's avatar
shaw1976
Frequent Visitor
2 years ago

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.