output from script

[tsa]

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.

[v-chuncz-msft · Accepted 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]

Thank you!