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,

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
9 years ago

I did send a frown to MS and followed up with an email on how to replicate the issue. They may come back and say "too bad" but worth a shot.

Anonymous's avatar
Anonymous
Not applicable
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,

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    9 years ago

    Sounds like I need to update my MRO!