Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Can someone explain why this R script is not allowed to return environment information in Power BI?
If I run it in RGui then I receive the Windows username as expected
let source = R.Execute("Sys.getenv(""USERNAME"")") in source
Solved! Go to Solution.
Hi @Brian_M,
I can reproduce your issue, even if I test "OS", "Path" but I still get the empty result. I also try to use "get data" from R script and get the same result.
Can you directly use R script to get the environment variables? If you can, it may means power bi not allow use R script to get environment information.
In addition, you can take a look at below article about using R script:
Running R Scripts in Power BI Desktop
Regards,
Xiaoxin Sheng
Hi @Brian_M,
I can reproduce your issue, even if I test "OS", "Path" but I still get the empty result. I also try to use "get data" from R script and get the same result.
Can you directly use R script to get the environment variables? If you can, it may means power bi not allow use R script to get environment information.
In addition, you can take a look at below article about using R script:
Running R Scripts in Power BI Desktop
Regards,
Xiaoxin Sheng
Thanks for the link. Yes, it works when used directly in R so it appears that Power BI is sandboxed in some way that it can't read that type of information.
User | Count |
---|---|
126 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |