Forum Discussion
perpor
Helper V
Helper VPower 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"...
Yes, just add the named variable in a previous step, for example:
let
myVar = "66",
Source = "myUrl" & myVar
in
SourceThis returns "myUrl66"
deldersveld
Resident Rockstar
Resident RockstarYes, just add the named variable in a previous step, for example:
let
myVar = "66",
Source = "myUrl" & myVar
in
Source
This returns "myUrl66"
perporthanks, it works... (the best would be to have global variables, for all the report, but this is already helpful..)
- deldersveld
Try looking into parameters. They can be used across queries.
- v-huizhn-msft
Microsoft Employee
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