topic Re: How can I use dygraphs library ( R) in powerbi? in Custom Visuals Development Discussion

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

Anonymous — Mon, 04 Nov 2019 22:00:31 GMT

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

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

v-evelk — Thu, 07 Nov 2019 12:46:31 GMT

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

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

Anonymous — Thu, 07 Nov 2019 13:02:16 GMT

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?

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

v-evelk — Fri, 08 Nov 2019 13:48:52 GMT

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