cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Jackofall Resolver I
Resolver I

Interactive directed flow graph

Hi.
I'm trying to fidle around with this graph and watched the video https://youtu.be/AHNlkjRFdYI

I tried to make a small data sample that would fill the prereqs numeric caseid, activity and timestamp. I guess i miss enough information about how my sample data need to look. I fail both using datetime and time in the Timestamp-field.

'Can't display this visual' R script error Warning messages there is no package called XML.

 

Any more information would be appreciated.

Skärmklipp.PNG

 

My data looks like;

case, activity, datetime, time

1000, first, 2019-01-06 07:35:14, 07:35:14

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft v-jiascu-msft
Microsoft

Re: Interactive directed flow graph

Yes, some packages are missing. The package is downloaded and checked finally. You can ignore the detail and watch the installation result.

 

Best Regards,
Dale

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

View solution in original post

8 REPLIES 8
Microsoft v-jiascu-msft
Microsoft

Re: Interactive directed flow graph

Hi @Jackofall,

 

There could be two possibilities. If the packages are missing, please refer to 1 in the snapshot below. If the packages are already installed, please refer to 1 in the snapshot below.

Interactive-directed-flow-graph

 

 

Best Regards,
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Jackofall Resolver I
Resolver I

Re: Interactive directed flow graph

Doh, I had not run the install bit. Temporary storage = C:\Users\xyz\Microsoft\Power BI Desktop Store App\RPBI

R Settings.xml use that path in ROutputDirectoryOverride

 

After the succeded install of the package I still get the error message about not loading.
"Feedback Type:
Frown (Error)

Timestamp:
2019-01-09T06:31:32.6560687Z

Local Time:
2019-01-09T07:31:32.6560687+01:00

Session ID:
ff090ab0-fbbb-4e3b-b616-b78139c99adb

Release:
December 2018

Product Version:
2.65.5313.621 (18.12) (x64)

Error Message:
R script error.
Loading required package: XML
Warning messages:
1: In library(package, lib.loc = lib.loc, character.only = TRUE, logical.return = TRUE,  :
  there is no package called 'XML'
2: In libraryRequireInstall("XML") :
  *** The package: 'XML' was not installed ***
Loading required package: htmlwidgets
Warning messages:
1: In library(package, lib.loc = lib.loc, character.only = TRUE, logical.return = TRUE,  :
  there is no package called 'htmlwidgets'
2: In libraryRequireInstall("htmlwidgets") :
  *** The package: 'htmlwidgets' was not installed ***
Loading required package: plyr
Warning messages:
1: In library(package, lib.loc = lib.loc, character.only = TRUE, logical.return = TRUE,  :
  there is no package called 'plyr'
2: In libraryRequireInstall("plyr") :
  *** The package: 'plyr' was not installed ***
Loading required package: lubridate

Attaching package: 'lubridate'

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

    date

Loading required package: visNetwork
Warning messages:
1: In library(package, lib.loc = lib.loc, character.only = TRUE, logical.return = TRUE,  :
  there is no package called 'visNetwork'
2: In libraryRequireInstall("visNetwork") :
  *** The package: 'visNetwork' was not installed ***
Error in loadNamespace(name) : there is no package called 'plyr'
In addition: Warning message:
In if (!is.na(ymd_hms(ev$time))) try(ev$time <- lubridate::ymd_hms(ev$time)) :
  the condition has length > 1 and only the first element will be used
Error in visNetwork(nodes = data.frame(id = character(0)), edges = data.frame(from = character(0)),  :
  could not find function "visNetwork"
Execution halted


OS Version:
Microsoft Windows NT 10.0.17134.0 (x64 sv-SE)

CLR Version:
4.7 or later [Release Number = 461808]

Peak Virtual Memory:
38.5 GB

Private Memory:
508 MB

Peak Working Set:
650 MB

IE Version:
11.472.17134.0

User ID:
ea47aa81-d5c5-4d53-a9f8-9ccfc97df985

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

Telemetry Enabled:
True

Model Default Mode:
Import

Snapshot Trace Logs:
C:\Users\vinlen\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot1061487751.zip

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

Disabled Preview Features:
PBI_shapeMapVisualEnabled
MIntellisense
PBI_SpanishLinguisticsEnabled
PBI_PdfImport
PBI_ColumnProfiling
PBI_variationUIChange
PBI_PythonSupportEnabled
PBI_showIncrementalRefreshPolicy
PBI_showManageAggregations
PBI_FuzzyMatching
PBI_EnableWebDiagramView
PBI_improvedFilterExperience
PBI_qnaLiveConnect

Disabled DirectQuery Options:
PBI_DirectQuery_Unrestricted
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
100%

Supported Services:
Power BI

Formulas:


section Section1;

shared #"Sheet1 (2)" = let
    Source = Excel.Workbook(File.Contents("C:\Users\vinlen\Documents\Power BI\Test flöde.xlsx"), null, true),
    Sheet1_Sheet = Source{[Item="Sheet1",Kind="Sheet"]}[Data],
    #"Promoted Headers" = Table.PromoteHeaders(Sheet1_Sheet, [PromoteAllScalars=true]),
    #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"case", Int64.Type}, {"activity", type text}, {"Timestamp", type datetime}}),
    #"Duplicated Column" = Table.DuplicateColumn(#"Changed Type", "Timestamp", "Timestamp - Copy"),
    #"Extracted Time" = Table.TransformColumns(#"Duplicated Column",{{"Timestamp - Copy", DateTime.Time, type time}})
in
    #"Extracted Time";

shared Sheet2 = let
    Source = Excel.Workbook(File.Contents("C:\Users\vinlen\Documents\Power BI\Test flöde.xlsx"), null, true),
    Sheet2_Sheet = Source{[Item="Sheet2",Kind="Sheet"]}[Data],
    #"Promoted Headers" = Table.PromoteHeaders(Sheet2_Sheet, [PromoteAllScalars=true]),
    #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Source", type text}, {"Target", type text}, {"Value", Int64.Type}})
in
    #"Changed Type";

shared #"log pbi" = let
    Source = Csv.Document(File.Contents("C:\Users\vinlen\Documents\Power BI\log pbi.csv"),[Delimiter=";", Columns=9, Encoding=1252, QuoteStyle=QuoteStyle.None]),
    #"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),
    #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"pk", Int64.Type}, {"title", type text}, {"arendeNo", Int64.Type}, {"arendenr", type text}, {"processStatus", type text}, {"processStatusDate", type datetime}, {"created_at", type datetime}, {"updated_at", type datetime}, {"fk", Int64.Type}})
in
    #"Changed Type";"

Microsoft v-jiascu-msft
Microsoft

Re: Interactive directed flow graph

Hi @Jackofall,

 

Did you have these packages installed? It seems they are really missing.

 

Best Regards,
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Jackofall Resolver I
Resolver I

Re: Interactive directed flow graph

Skärmklipp.PNG

Seems my environment is not set up properly before I loaded the package?

Microsoft v-jiascu-msft
Microsoft

Re: Interactive directed flow graph

Yes, some packages are missing. The package is downloaded and checked finally. You can ignore the detail and watch the installation result.

 

Best Regards,
Dale

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

View solution in original post

Jackofall Resolver I
Resolver I

Re: Interactive directed flow graph

OK. I totally misunderstood the error message. /facepalm

I had to load ALL of the packages in the error message. Once I did that I got No activity or bad input log in my tile. Happy camper!

Now I can set out to find me som proper log data and move on.

Thank you and have th best of days @v-jiascu-msft

rtaylor Helper II
Helper II

Re: Interactive directed flow graph

Hello,

 

Did you ever figure out what the problem was? I'm still stuck on the no activity bad input log on the Power Bi Desktop.

 

Any help would be greately appreciated.

Jackofall Resolver I
Resolver I

Re: Interactive directed flow graph

Yes. When I did the same thing all over again, loading one package at a time it finally worked. The installation process gives bad support so read every thing with attention. Write down the packages names, install them manually one at a time in the console window.

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.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors