Table with R Script

[sezerunar]

Hi there,

I am trying to make a table visual with Rscript.

The below is my code:

# The following code to create a dataframe and remove duplicated rows is always executed and acts as a preamble for your script:

# dataset <- data.frame(unique)

# dataset <- unique(dataset)

# Paste or type your script code here:

library(DT)

DT::datatable(dataset)

However, it doesn't return any visual. It says "No image was created. The R code didn't result in creation of any visuals. Make sure your R scripts results in a plot to the R default device."

I can make ggplot2 visuals, but why not DT table or GT table?

[Anonymous · Accepted solution]

Hi @sezerunar ,

This error message suggests that the DT::datatable function is not generating a plot. The DT package is designed to create interactive tables in R, but it may not be compatible with Power BI.

Please try to use a different package: Instead of , you could use the package to create a table as a static plot. This way, the visual can be rendered as an image in Power BI. 

library(ggplot2)
library(gridExtra)

# Assuming 'dataset' is your data frame
# Create a simple table visual using 'tableGrob' function from 'gridExtra' package
table <- tableGrob(dataset)
grid.draw(table)

This will create a static table visual as an image that Power BI can display.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.