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,

Anonymous's avatar
Anonymous
Not applicable
9 years ago

The script I'm using is the simplest of all kinds and full code is:


library(corrplot)

M<- cor(dataset, use="pairwise.complete.obs")
corrplot(M,method="circle")

 

As you say, corrplot is a supported package according to Microsoft and I find it hard to believe that my use of the function should be of any special difficulty for the R-engine  to handle?

 

Greg_Deckler's avatar
Greg_Deckler
Community Champion
9 years ago

You have any sample data? I could try to replicate your issue.

 

Just as an aside, I assume this works fine in Desktop and in your R IDE?

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Thanks, it would be great to see if it works for you.

     

    You can find some sample data here csv file

     

    The fields that I use to calculate the correlation is: ActualPrice.2, Fee.1, LandArea.1, Rooms, Size.1 and SupplArea.1

     

    And yes, it works fine when I run this in Power BI Desktop 

    • Greg_Deckler's avatar
      Greg_Deckler
      Community Champion
      9 years ago

      Well, I replicated it, but in the Desktop!!

       

       

      I should note however that I am using Microsoft's MRO Rgui 3.2.3 64-bit as my R runtime. I am betting that you are using something else and I am further betting that whatever Power BI is running is probably more along the lines of what I am running versus what you are running.

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Well then I rest my case... I guess the version that I'm running (some old oracle distribution 3.1.1) might take some "shortcut" when calculating the correlation matrix and therefore is able to create and display the visual in Desktop...

         

        I will install a newer distribution of R and try again, my guess is that it then will fail for me as well...

         

        Thanks anyway for your help!