cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Bartira
Frequent Visitor

How can I use dygraphs library ( R) in powerbi?

I can not see how to interact with the powerBI dataset. I'm using a simple chart. I can run using Rstudio but I can't run the same code using R visual in powerBI.

 

 

library("xts")
library("dygraphs")

 

QC$Timestamp <- as.Date(as.character(QC$Timestamp))

QC_xts <- xts(QC$XS,order.by=QC$Timestamp,frequency=365)

 

QCData <- cbind(QC_xts)

dygraph(QCData,ylab="Timestamp", main="XPTO") %>%

# dySeries("QC_xts",label="XS") %>%

# dySeries("..2",label="LNKD") %>%

dyOptions(colors = "blue") %>%

dyRangeSelector()

 

The erro is display any chart just X. PBI show this error: An exception of type Microsoft.PowerBI.ExploreServiceCommon.ContainPIIException occured.

 

@alcirodata 

3 REPLIES 3
Microsoft v-evelk
Microsoft

Re: How can I use dygraphs library ( R) in powerbi?

Hello,

 

Regarding interaction with dataset, I suppose, you should use the same approach as in this line to pass name of buckets.

Regarding other moments, check please that libraries that you use are imported in R Studio.

Also, check please that integration into Power Bi Desktop is set up: File -> Options and settings -> Options -> R scripting

 

Kind Regards,

 

Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals
pbicvsupport@microsoft.com

Bartira
Frequent Visitor

Re: How can I use dygraphs library ( R) in powerbi?

Thanks for your reply. Should I work the same way I work with plotly? Plotly doesn't work on R visual just pbiviz. Is it the same for dygraphs? Does it work well for large data?

Microsoft v-evelk
Microsoft

Re: How can I use dygraphs library ( R) in powerbi?

Hello,

 

- "Should I work the same way I work with plotly?"

Could you clarify your question please, becuase I am unsure that I got it.

 

- "Plotly doesn't work on R visual just pbiviz. Is it the same for dygraphs?"

What do you mean?

 

- "Does it work well for large data?"

It have to work with 150 000 rows regarding documntation.

 

Kind Regards,

 

Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals
pbicvsupport@microsoft.com

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.

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