Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!