Forum Discussion
Keep data refreshed in Power BI Service when a dataset uses an R script
Hello, I have a pbix file that imports a dataset from an R package (in Power Query). It works well, but I can't keep this dataset refreshed on Power BI Service. Data flows do not support R scripts...
R is supported as a data source for Power BI Service. I am having issues translating the error since it is an image.
Hi Greg_Deckler thanks for reaching out.
The data flow error message is the following:
Expression.Error: The import R.Execute matches no exports. Did you miss a module reference?section Section1;
shared Query = let
Origem = 1,
#"Convertido em Tabela" = #table(1, {{Origem}}),
#"Executar script do R" = R.Execute("# 'dataset' contém os dados de entrada neste script#(lf)library(tidycovid19)#(lf)covid19_dta <- download_merged_data(silent = TRUE, cached = TRUE)",[dataset=#"Convertido em Tabela"]),
#"""covid19_dta""" = #"Executar script do R"{[Name = "covid19_dta"]}[Value]
in
#"""covid19_dta""";
And the data gateway message:
Failed to update data source credentials: Tipo de excepção 'Microsoft.Analytics.Modules.R.ErrorHandling.RException.Primitives.NotValidRDataException' accionado.Hide details
Activity ID: 344d481a-c827-4527-8f9c-9b4d8f1d590b
Request ID: 98296050-66ba-2f39-459c-78fc143b82b1
Status code: 400
Time: Sat Apr 11 2020 18:49:43 GMT+0100 (Hora de verão da Europa Ocidental)
Service version: 13.0.12739.219
Client version: 2003.3.022
Cluster URI: https://wabi-europe-north-b-redirect.analysis.windows.net/
And: