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. 

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.