Forum Discussion

perpor's avatar
perpor
Helper V
9 years ago
Solved

Power BI advaced query Editor

good morning   I am searching if it possible to use variables, in the advanced query editor, something like this:   instead of: ------------   let Origine = Sql.Database("99.99.99.99", "Mydb"...
Need Help
  • deldersveld's avatar
    deldersveld
    9 years ago

    Yes, just add the named variable in a previous step, for example:

     

    let
        myVar = "66",
        Source = "myUrl" & myVar
    in
        Source

     

     

    This returns "myUrl66"

perpor's avatar
perpor
Helper V
9 years ago

thanks, it works... (the best would be to have global variables, for all the report, but this is already helpful..)

v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
9 years ago

Hi perpor,

If you have resolved your issue according the helpful reply, please mark it as answer, so other people can find workaround clearly.

Thanks,
Angelia