Forum Discussion
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.
3 Replies
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
[email protected]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
[email protected]
