topic Re: R Custom Visual - using data from R script (not importing from Power BI) in Custom Visuals Development Discussion

R Custom Visual - using data from R script (not importing from Power BI)

Anonymous — Wed, 28 Jul 2021 14:20:58 GMT

I was following this tutorial: https://docs.microsoft.com/en-us/power-bi/developer/visuals/funnel-plot-from-r

My impression was that "dataset.csv" file was read in with "read.csv" function in the R script which was used for the plot. But when I import the visual to Power BI it asks me to import the CSV file in Power BI.

As a simpler example, with the template code given here:

g = qplot(`Petal.Length`, data = iris, fill = `Species`, main = Sys.time());

I thought it was going to use the "iris" dataset when imported but it again asks me to import a source dataset.

My intention is to read in the data in R script (e.g. from web) to use them for the plots, without again importing the data in Power BI.

Would this be possible? Any help would be appreciated!

Re: R Custom Visual - using data from R script (not importing from Power BI)

lbendlin — Wed, 28 Jul 2021 23:52:49 GMT

Have you changed this line

dataset = read.csv(file = "dataset.csv", header = TRUE, sep = ",", stringsAsFactors = FALSE)

to point to a web based data file instead?

Re: R Custom Visual - using data from R script (not importing from Power BI)

Anonymous — Sat, 31 Jul 2021 21:29:49 GMT

Thanks @lbendlin , I've tried and it works. Only one caveat is that I still need to supply any data to get it working (even if it's nothing to do with the data for plotting). Looks like this is the best I can? I wonder if there's any way to omit the step of putting the data itself in Power BI? Thank you!

Re: R Custom Visual - using data from R script (not importing from Power BI)

lbendlin — Sat, 31 Jul 2021 22:29:22 GMT

Yes. Use a different tool instead of Power BI.