Is it possible to use R scripts as a data source for PowerBI when published to the PowerBI Service?
I have a PowerBI file that uses R scripts as a data source. The scripts access a database, query and manipulate a few existing tables, and then imports the resulting table into PowerBI. The scripts run well on PowerBI Desktop but unfortunately when attempting to publish this to the PowerBI service, I am running into a gateway issue. I am using an On-premise data gateway that can successfully connect to the SqlServer, but spits back an error related to R: Extension{"extensionDataSourceKind":"R","extensionDataSourcePath":"R"}
Scouring the PowerBI support forums and resources, everything that I have found only talks about generating visuals using R, and I have yet to find a resource talking about using R scripts as a datasource for PowerBI. I found this stackoverflow thread from 2019, but have yet to find anything more recent.
Is it possible to use R scripts as a data source when publishing a file to the PowerBI service?
Using an R or Python data source in Power Query only supports the Personal Mode gateway.
After you've uploaded the .pbix file to the Power BI service, you need to take other steps to enable service data refresh and updated visuals:
Enable scheduled refresh for the semantic model: To enable scheduled refresh for the workbook containing your semantic model with R scripts, see Configuring scheduled refresh. This article also includes information about on-premises data gateways.
Install a gateway: You need an on-premises data gateway (personal mode) installed on the machine where the file and R are located. The Power BI service accesses that workbook and re-renders any updated visuals. For more information, see use personal gateways in Power BI.
- Assign groups in dataframe using vectors containing start and end indexes
- Is there a product operator (or work around) in SQLite?
- Loading Magick package after tidyverse
- Make silhouette icons in tmap
- Ignoring NA cases when getting column index of lowest value in row
- plm object to LaTeX table
- Why is my bslib theme not coloring the navbar as expected?
- Adding a footnote to a single row label in a gtsummary table
- How to order a data frame by one descending and one ascending column?
- dplyr is turning dates to doubles when mutating dataframe
- How to display headers from a quarto with a for loop and plotly graphs?
- mixed date converted from default mm/dd/yy in excel to dd/mm/yy
- Git lfs version https://git-lfs.github.com/spec/v1 oid error
- Generate list of lead values
- How to find the date a categorical variable was last active?
- R - could not find function "cld"
- Overlay sf object on ggmap - not aligned, specific to region
- Using ggplot and alleffects in tandem
- Assign categories from JSON column in data table
- Opposite of tidyr::separate, concatenating multiple columns into one
- How to Stack Painted Phylogenetic Trees in R Like ggdensitree but with Colored Regimes
- Counting number of viable pathways in a network diagram from a specific node input
- Report p-value from lme model (random intercept) with gtsummary using tbl_summary() and add_p()
- dynamically remove all nav panel from tabsetPanel
- If x and y have the same length, do qqplot(x,y) and plot(sort(x),sort(y)) yield the same plot in R?
- Applying SPEI::hargreaves function to time series from each pixel of SpatRaster using terra package R?
- Turn dataframe with frequency into a frequency table for chi-square test
- Print result of a function in R
- How to require user authentication in R Shiny before users see any part of the app using shinyauthr?
- Determine foreground / background colour in bslib app with dark/light mode