Forum Discussion

rliu's avatar
rliu
Icon for Helper I rankHelper I
10 years ago
Solved

R visuals in power BI

I am trying to plot a histogram of one of my columns using R. My code works totally fine in R but it won't work in Power BI. Anybody knows why and how to solve this? Appreciate your help. So ...
  • rliu's avatar
    rliu
    10 years ago

    ankitpatira, in this case all the values are  less than 20 so no separaters.  But what you brought up is a good point! Thank you. I end up just ploting a line/bar chart directly in power BI.

BeardyGeorge's avatar
BeardyGeorge
Icon for Advocate I rankAdvocate I
10 years ago

if the solutions provided by other users don't work, I would recommend you run this r code on your dataframe and paste the output here:

library(gridExtra)
grid.table(summary(dataset))

 

what it does:

 

Allows you to output a table from an R script to the visualisation window. The results of the "summary" function should show us what's going on.

  • rliu's avatar
    rliu
    Icon for Helper I rankHelper I
    10 years ago

    BeardyGeorge That's a great tip to know! Thanks.

    • BeardyGeorge's avatar
      BeardyGeorge
      Icon for Advocate I rankAdvocate I
      10 years ago

      No problem - it's saved me a fair bit of time trying to figure out the cryptic messages PowerBI gives you.

       

      My first guess would be that your PowerBI query is referencing Days.Undecided and your R script there is calling Days_Undecided.