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

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! 

    • Greg_Deckler's avatar
      Greg_Deckler
      Community 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,