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 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.

 

Need Help

7 Replies

  • PwerQueryKees's avatar
    PwerQueryKees
    Super User
    2 years ago

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

      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.

    • shaw1976's avatar
      shaw1976
      Frequent Visitor
      2 years ago

      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.

       

       

  • PwerQueryKees's avatar
    PwerQueryKees
    Super User
    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.