Forum Discussion

datamunger1245's avatar
datamunger1245
Frequent Visitor
8 years ago

R script and R visuals in Power BI

I am working in PBI and made some updates to my underlying data stored in a csv.  The updates were in a categorical variable column and upon refreshing the data in PBI I get an error message stating ...
v-piga-msft's avatar
v-piga-msft
Resident Rockstar
8 years ago

Hi  datamunger1245,

 

If I understand your scenario correctly that your report contains R visual and you get this error when you modify the underlying data source?

 

How do you modify the data source?

 

If it is convenient, could you share your error message with screenshot?

 

Best Regards,

Cherry

  • datamunger1245's avatar
    datamunger1245
    Frequent Visitor
    8 years ago

    Sorry - that initial post could have been a bit more clear.  I was working with my data in Rstudio to tidy it up.  Saved my data as a csv and loaded it up in PBI.  I notice PBI doesn't deal with NAs and when there's one or more in the column where I should have numeric values.  PBI views the column as a text column data type.  Upon noticing this, I went back into R to omit my NAs, saved the csv and loaded it up into PBI w/out NAs.  However, PBI still won't view the column as a numeric data type....even after refreshing and multipe saves to the csv pulling out NAs.  

     

    It would be great if PBI could deal with NAs.  Second is there a way PBI can refresh correctly to view my underyling data.