Forum Discussion
R print or summary visualization
Does anyone know how you can show the result of an R script in a dashboard? And I don't mean the charts, but for example the result of the r script : input <- warpbreaksprint(head(input)) ou...
it's a bit of a workaround, but the gridExtra package should be able to do what you're after - grid.table() instead of print can be used to display the result of the summary function (see here for more detail on what it can do).
Note that this might not be completely what you're after, as it produces an image and displays that, rather than an actual table you can copy data out of.
Another way would be to save the output in a text file and then create a table visual in PowerBi and pull the data with 0 width. The issue here is one would need to refresh the table visual.
require(gridExtra) pathToProject <- "F:\\PowerBIDocuments\\" t <- summary(dataset$hwy) grid.table(t) out <- capture.output(t) cat(out, file=paste0(pathToProject,"results.txt"), sep="\n", append=FALSE)