cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Shaney Helper I
Helper I

R visual not working since update August 2019 Power BI

Dear Community,

 

I've had no problems with the R-visuals until the update of Power BI August 2019.

 

I've the following error in Power BI Cloud using a R-visual:

Attaching package: 'dplyr' The following objects are masked from 'package:stats': filter, lag The following objects are masked from 'package:base': intersect, setdiff, setequal, union Attaching package: 'psych' The following objects are masked from 'package:ggplot2': %+%, alpha Attaching package: 'magrittr' The following object is masked from 'package:tidyr': extract Error: Can't subset with `[` using an object of class NULL. Call `rlang::last_error()` to see a backtrace  

 

The R-visuals all work in the Power BI Desktop but when I publish the report to the cloud the above error message appears for 1 specific visual. This happened since installing the new update of Power BI August 2019. I have already reinstalled Power BI August 2019 version and removed all the NULL-values in the dataset.

 

See the R-script below:

# De volgende code voor het maken van een gegevensframe en het verwijderen van dubbele rijen wordt altijd uitgevoerd en fungeert als een preamble voor het script: 

# dataset <- data.frame(ID, Activity, EventTime, Attribute, #Cost)
# dataset <- unique(dataset)

# Plak of typ uw scriptcode hier:
list.of.packages <- c("tidyr", "dplyr", "ggplot2", "psych", "magrittr", "ggpubr")
new.packages <- list.of.packages[!(list.of.packages %in% installed.packages()[,"Package"])]
if(length(new.packages)) install.packages(new.packages)

library(tidyr)
library(dplyr)
library(ggplot2)
library(psych)
library(magrittr)
library(ggpubr)

dataset <- data.frame(dataset$ID, dataset$Activity, dataset$EventTime, dataset$Shift, dataset$'#Cost')
dataset <- unique(dataset)

dataset$dataset.Attribute<- as.character(dataset$dataset.Attribute)
dataset$dataset...Cost. <- as.numeric(dataset$dataset...Cost.)

ggdensity(dataset, x = "dataset...Cost.", add = "mean", 
          rug = TRUE, color = "dataset.Attribute", fill = "dataset.Attribute")

Can someone help me solving this issue?

3 REPLIES 3
Community Support
Community Support

Re: R visual not working since update August 2019 Power BI

Hi @Shaney ,

Please enable desktop trace log, repeat steps until error occurs, share trace log files with us. For a workaroud, you could download a previous version and use that to publish your report. 

Previous monthly updates to Power BI Desktop

 

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Shaney Helper I
Helper I

Re: R visual not working since update August 2019 Power BI

Hi @v-xuding-msft ,

 

Thanks for your reply!

I have uploaded the traces as you mentioned in this link: https://transfernow.net/383453m8trbi

Is this file the file you were looking for?

 

I appreciate your help.

 

Kind regards,

 

Shaney

Shaney Helper I
Helper I

Re: R visual not working since update August 2019 Power BI

@v-xuding-msft  Was it possible for you to download the trace logs?

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Top Kudoed Authors