Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi, I have created two R scripts script1 and script2
script1 saves the dataframe using saveRDS function into a local directory
script2 reads the saved dataframe and displays the data.
The problem is that script1 reacts to a selection I make via a "slicer" dropdown but script2 does not. Only after manually running script2 by clicking "run script" button do I get a reaction. Any idea how I could trigger script2 to react to the changed script1's saved data?
Code of script1
library(gridExtra) # Displaying data onto Power BI Desktop library(dplyr) # For data munging pathToProject <-"F:\\PowerBiDocuments\\" df1 <- group_by(dataset, manufacturer) %>% summarise('avg_cty_mileage' = mean(cty), 'avg_hwy_mileage' = mean(hwy)) saveRDS(df1, paste0(pathToProject,"df1"))
Code of script2
require(gridExtra) require(ggplot2) pathToProject <- "F:\\PowerBiDocuments\\" df2 <- readRDS(paste0(pathToProject,"df1")) grid.table(df2)
Solved! Go to Solution.
No, it's not possible. You must click the "run script" or click "Refresh" to make the R visual take the slicer selection and execute the script again. You may create a feature request on idea.
Regards,
Hey,
I just curious, why can't you just combine both scripts into one like so
library(gridExtra) # Displaying data onto Power BI Desktop library(dplyr) # For data munging df1 <- group_by(dataset, manufacturer) %>% summarise('avg_cty_mileage' = mean(cty), 'avg_hwy_mileage' = mean(hwy))
grid.table(df1)
Regards
Tom
Hey,
I'm not sure if this will help, but maybe you are not aware of the function "grid.arrange"
This little script
library(ggplot2) library(gridExtra) df <- data.frame(cat = c("A", "B"), amount = c(110, 120)) p1 <- ggplot() p1 <- p1 + geom_col(data = df, aes(x = cat, y = amount))
# here starts the modification of the data.frame df that than can used with the function tableGrob
# create a grob (graphical object) from a data frame p2 <- tableGrob(df)
# this creates a single plot that contains "two different plots" that also can be arranged in almost
# any way you want use ?grid.arrange to the documentation of grid.arrange grid.arrange(p1, p2)
creates this output
Maybe this is what you are looking for
Regards Tom
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
83 | |
64 | |
61 | |
55 |
User | Count |
---|---|
179 | |
108 | |
105 | |
71 | |
70 |