Open Side Menu
Skip to contentBrand Logo
Forums
Inspiration
Ideas
Communities
Blogs
Learning
Support
RegisterSign In
  1. Microsoft Fabric Community
  2. Power BI forums
  3. Galleries
  4. R Script Showcase
fathomson's avatar
fathomson
Advocate II
9 years ago

Schedule view

  Description A relatively simple visualization to show start-stop of events at locations. Can be roomscheduling but also a production process with specific states at a given time. Although i...
schedules_in_powerbi_with_r.pbix381 KB
General R Visualizations
C_Houghton's avatar
C_Houghton
Frequent Visitor
8 years ago

Thanks for your reply! That would be absolutely perfect, but i'm getting errors:

 

Feedback Type:
Frown (Error)

Timestamp:
2017-10-23T07:56:28.6198256Z

Local Time:
2017-10-23T08:56:28.6198256+01:00

Product Version:
2.47.4766.801 (PBIDesktop) (x64)

Release:
June 2017

IE Version:
11.608.15063.0

OS Version:
Microsoft Windows NT 10.0.15063.0 (x64 en-GB)

CLR Version:
4.6.2. or later [Release Number = 460798]

Workbook Package Info:
1* - en-US, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: True.

Peak Working Set:
386 MB

Private Memory:
271 MB

Peak Virtual Memory:
33.8 GB

Error Message:
R script error.
Loading required package: ggplot2
Loading required package: grid
Loading required package: gridExtra
Warning message:
package 'gridExtra' was built under R version 3.4.2
Loading required package: wesanderson
Warning message:
package 'wesanderson' was built under R version 3.4.2
Loading required package: RColorBrewer
Loading required package: dplyr
Warning messages:
1: In library(package, lib.loc = lib.loc, character.only = TRUE, logical.return = TRUE, :
there is no package called 'dplyr'
2: In libraryRequireInstall("dplyr") :
*** The package: 'dplyr' was not installed ***
Error in `levels<-`(`*tmp*`, value = if (nl == nL) as.character(labels) else paste0(labels, :
factor level [2] is duplicated
Calls: sortDataset -> factor
Execution halted


User ID:
db15c5fa-a129-4ae0-ba08-f5149b97bbcb

Session ID:
89517680-55f3-4784-b47f-0655edbd950b

Telemetry Enabled:
True

Model Default Mode:
Import

Snapshot Trace Logs:
C:\Users\ch1\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot293130851.zip

Performance Trace Logs:
C:\Users\ch1\AppData\Local\Microsoft\Power BI Desktop\PerformanceTraces.zip

Enabled Preview Features:
PBI_Snowflake
PBI_shapeMapVisualEnabled
PBI_EnableReportTheme
PBI_allowBiDiCrossFilterInDirectQuery
PBI_pivotTableVisualEnabled
PBI_numericSlicerEnabled
PBI_daxTemplatesEnabled
PBI_relativeDateSlicer
CustomConnectors

Disabled Preview Features:
PBI_SpanishLinguisticsEnabled
PBI_PbiServiceLiveConnect

Disabled DirectQuery Options:
PBI_DirectQuery_Unrestricted

Cloud:
GlobalCloud

Time:
Mon Oct 23 2017 08:55:49 GMT+0100 (GMT Summer Time)

Client Error Code:
ServiceErrorToClientError

Error Details:
R script error.
Loading required package: ggplot2
Loading required package: grid
Loading required package: gridExtra
Warning message:
package 'gridExtra' was built under R version 3.4.2
Loading required package: wesanderson
Warning message:
package 'wesanderson' was built under R version 3.4.2
Loading required package: RColorBrewer
Loading required package: dplyr
Warning messages:
1: In library(package, lib.loc = lib.loc, character.only = TRUE, logical.return = TRUE, :
there is no package called 'dplyr'
2: In libraryRequireInstall("dplyr") :
*** The package: 'dplyr' was not installed ***
Error in `levels<-`(`*tmp*`, value = if (nl == nL) as.character(labels) else paste0(labels, :
factor level [2] is duplicated
Calls: sortDataset -> factor
Execution halted


Stack Trace:
Microsoft.PowerBI.ExploreServiceCommon.ScriptHandlerException: R script error.
Loading required package: ggplot2
Loading required package: grid
Loading required package: gridExtra
Warning message:
package 'gridExtra' was built under R version 3.4.2
Loading required package: wesanderson
Warning message:
package 'wesanderson' was built under R version 3.4.2
Loading required package: RColorBrewer
Loading required package: dplyr
Warning messages:
1: In library(package, lib.loc = lib.loc, character.only = TRUE, logical.return = TRUE, :
there is no package called 'dplyr'
2: In libraryRequireInstall("dplyr") :
*** The package: 'dplyr' was not installed ***
Error in `levels<-`(`*tmp*`, value = if (nl == nL) as.character(labels) else paste0(labels, :
factor level [2] is duplicated
Calls: sortDataset -> factor
Execution halted

 

Any insights off the bat? Or I can follow it up with the creator.

 

Thanks again

boefraty's avatar
boefraty
Microsoft Employee
8 years ago

Hi C_Houghton, 

 

*** The package: 'dplyr' was not installed *** 

 

Try to install it manually from RStudio

 

> install.packages("dplyr") 

 

  • C_Houghton's avatar
    C_Houghton
    Frequent Visitor
    8 years ago

    Hi there,

     

    I installed that package - looks slightly better:

     

    Error Details:

    R script error.

    Loading required package: ggplot2

    Loading required package: grid

    Loading required package: gridExtra

    Warning message:

    package 'gridExtra' was built under R version 3.4.2

    Loading required package: wesanderson

    Warning message:

    package 'wesanderson' was built under R version 3.4.2

    Loading required package: RColorBrewer

    Loading required package: dplyr

     

    Attaching package: 'dplyr'

     

    The following object is masked from 'package:gridExtra':

     

        combine

     

    The following objects are masked from 'package:stats':

     

        filter, lag

     

    The following objects are masked from 'package:base':

     

        intersect, setdiff, setequal, union

     

    Error in `levels<-`(`*tmp*`, value = if (nl == nL) as.character(labels) else paste0(labels,  :

      factor level [2] is duplicated

    Calls: sortDataset -> factor

    Execution halted 

    • boefraty's avatar
      boefraty
      Microsoft Employee
      8 years ago

      Hi, 

      Make sure Dates are not hierarchies and no summary applied on other fields. 

      You welcome to send me the PBIX and I'll have a look . 

      boefraty @  microsoft  .  com 

  • © 2026 Microsoft
  • Manage cookies
  • Privacy & cookies
  • Terms of use
  • Trademarks
Your Privacy Choices Consumer Health Privacy