Power BI Custom R Visual - How to display a table generated in r?

[Anonymous]

I am having trouble with an R Visual I am creating in Power BI. I am acually trying to display a table, however, whenever I bring in a table I create in R using one of the supported R libraries in the Power BI documentation, I receive a "This visual cannot be displayed" error.

Here is the documentation I'm referencing https://docs.microsoft.com/en-us/power-bi/connect-data/service-r-packages-support ... in particular, I would like to display a table created in r using the "htmlTable" library. At this point, I will take the simplest option available so long as it displays the information I need it to correctly.

The best I can generate so far is as follows, using the "grid.table()" function in R. Please ignore the red outline white boxes as those hide sensitive data:

The R visual is the bottom visual, and it pulls into Power BI in a distorted view, as you can see in the screenshot.

Every table visual I have created in R does not work in Power BI. Is there an easier way or known method to do this?

[cavamic]

Hello - I was having a similar problem rending htmlTable but seemingly solved it . 

When creating an htmlTable, use its htmlTableWidget() function to create an htmlwidget instead of the basic htmlTable() which creates a character. I then passed this widget into save Widget from htmlwidgets package.  

table <- htmlwidget(mtcars)

saveWidget(table, 'out.html')

[Anonymous]

The output of an R script visual in Power BI needs to be an image format (PNG/JPG). There should be a few supported packages that can do this for you, such as webshot, if an export function isn't built-in. Just know image outputs aren't interactable.

If you need the visual to be interactable, the only option is to get into Power BI Custom Visual territory. Thankfully, there's an R based template and it's actually not that hard to get it running, but you may struggle with getting the correct version of XML installed (used to save html widgets for Power BI consumption in flatten_HTML). A workaround is to swap out the XML package with xml2 per this PR. Feel free to DM for help if you go this way.

Edit: This is an R script, right? Not an rhtml visual? Personally not a fan of MS's naming conventions, they cause a lot of confusion.