Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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", [Query="select data from mytab where code = 66....
in
Origine
something like this:
---------------------
let variab = 66;
let
Origine = Sql.Database("99.99.99.99", "Mydb", [Query="select data from mytab where code = variab .....
in
Origine
or any doc about ...
thanks
Solved! Go to Solution.
Yes, just add the named variable in a previous step, for example:
let
myVar = "66",
Source = "myUrl" & myVar
in
Source
This returns "myUrl66"
Yes, just add the named variable in a previous step, for example:
let
myVar = "66",
Source = "myUrl" & myVar
in
Source
This returns "myUrl66"
thanks, it works... (the best would be to have global variables, for all the report, but this is already helpful..)
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.