Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

R Script Error when viewing report on Powerbi.com

I have created a report where I use one simple R-visual. It's a basic correlation plot and it works perfectly when running in Power BI Desktop.   But when I have published the report and try to vie...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    This is actually quite strange... I installed latest version of Microsoft R Open on my machine and was still able to run the visual successfully on my Desktop with same data set.

     

    I then examined the data set a little more and I was aware of that some of the columns contained quite many nulls, I thought that shouldn't matter since I stated to use pairwise observations only in the cor function... But when I replaced all nulls with 0 and uploaded the new version to powerbi.com it actually rendered as it should...

     

     

    I don't fully understand how the cor function is supposed to handle nulls but in this case it actually makes sense to set null=0 in order to make the data set more logical. And since it then also executes properly i guess I'm happy for now :)

     

    Interesting to here if Microsoft comes back with some comment on your mail, please update this post if you receive some response.

     

    Thanks,