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"

deldersveld's avatar
deldersveld
Resident Rockstar
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..)

    • deldersveld's avatar
      deldersveld
      Resident Rockstar
      9 years ago

      Try looking into parameters. They can be used across queries.

    • 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