Forum Discussion

webportal's avatar
webportal
Impactful Individual
6 years ago

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...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago
R is supported as a data source for Power BI Service. I am having issues translating the error since it is an image.
  • webportal's avatar
    webportal
    Impactful Individual
    6 years ago

    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: