Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
how can I dynamically change a variable of a R script using the parameters of a template please !!
Solved! Go to Solution.
Hi @quantico,
In Power BI Desktop, we can run R script to import data, create R visual, and prepare your data model in Query Editor. As query parameter is used for retrieving data only currently, you shoud be able to call it when running R script to import data, and prepare your data model in Query Editor, but not to create R visual. ![]()
In adition, here is a similar thread for your reference. ![]()
let
Quelle = R.Execute("NormalNoise <- data.frame(x=rnorm(100, mean="&Text.From(Parameter1)&", sd=1))"),
EnvVars1 = Quelle{[Name="NormalNoise"]}[Value]
in
EnvVars1
Regards
Hi @quantico,
In Power BI Desktop, we can run R script to import data, create R visual, and prepare your data model in Query Editor. As query parameter is used for retrieving data only currently, you shoud be able to call it when running R script to import data, and prepare your data model in Query Editor, but not to create R visual. ![]()
In adition, here is a similar thread for your reference. ![]()
let
Quelle = R.Execute("NormalNoise <- data.frame(x=rnorm(100, mean="&Text.From(Parameter1)&", sd=1))"),
EnvVars1 = Quelle{[Name="NormalNoise"]}[Value]
in
EnvVars1
Regards
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 63 | |
| 55 | |
| 42 | |
| 41 | |
| 23 |
| User | Count |
|---|---|
| 166 | |
| 135 | |
| 120 | |
| 79 | |
| 53 |