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. 

Using my personal data gateway, I get the following error in the data source credentials:

Is there any solution for this problem, or is R incompatible as a data source for Power BI Service?

Thank You.

Need Help

3 Replies

  • 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:

  • Icey's avatar
    Icey
    Community Support
    6 years ago

    Hi webportal ,

     

    To my knowledge, Power BI Service supports some R visuals. Please pay attention to limitations.

     

    But in Dataflow, R script is not supported as a data source currently.

     

    There are some similar ideas you can vote up:

    Create Dataflows using R script;

    Creating Dataflows using R or Python scripts as source;

    R Transform Power Query Dataflow.

     

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.