Forum Discussion

bkim's avatar
bkim
Frequent Visitor
7 years ago

R Script Runtime error occurs in Service but not Desktop

I'm getting an error from a visual that runs fine in PowerBI Desktop. When I click to edit the script in an external editor, the script runs fine there in R Studio as well when I run the script line-by-line

 

Here's the details of the error message - looks like it's caused by no data, but again, the script runs without issues with the same filters in Desktop:

 

Loading required package: ggplot2 Loading required package: magrittr Attaching package: 'ggpubr' The following object is masked from 'package:cowplot': get_legend Attaching package: 'gridExtra' The following object is masked from 'package:dplyr': combine Error in aggregate.data.frame(as.data.frame(x), ...) : no rows to aggregate
Please try again later or contact support. If you contact support, please provide these details.

Activity ID9cc106f6-a8fb-45ac-9314-79814fd39865
Request ID526dc762-2026-bd36-e214-915bb5d0bbb4
Correlation ID7590f0f4-50c3-b056-53bb-4f7dd493e826
TimeThu Jul 18 2019 12:58:25 GMT-0400 (Eastern Daylight Time)
Version13.0.10117.179

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    I have a similar Problem and found a solution by changing my variable names. It seems that the desktop version and R Studio can cope with blank spaces and characters as / ( ) [ ] etc. (of course only by putting them in between `  ` ).

     

    In my case, the online service couldn't deal with that, so I changed the variable names only using letters and numbers. Now my plot works!