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.
I'm trying to run a wilcoxon signed rank test through rscript in power query. I've tested loading the simple dataset in R and confirmed that it does return a significance value. In power bi, when I run the query, there's no results (empty table). So my question is when the results of an r script is a bunch of statistics values similar to wilcoxon output, how does power bi output it or how do write the R script to show the output so that I can simply display this isn a text visual or something (no graphs needed). Thank you in advance.
Solved! Go to Solution.
@tsa,
As mentioned at https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-r-scripts/#running-r-scripts, when preparing and running an R script in Power BI Desktop, only data frames are imported, so make sure the data you want to import to Power BI is represented in a data frame. Here the return value of wilcox.test is a list, you need to construct a data frame.
@tsa,
As mentioned at https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-r-scripts/#running-r-scripts, when preparing and running an R script in Power BI Desktop, only data frames are imported, so make sure the data you want to import to Power BI is represented in a data frame. Here the return value of wilcox.test is a list, you need to construct a data frame.
Thank you!
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.
User | Count |
---|---|
58 | |
20 | |
19 | |
18 | |
9 |