Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Usage of R query in published report

In a report, I load files from a Sharepoint folder and then I transform the data using the R query editor. I also use an R visual in the same dashboard.

 

If I only use the R visual and don't perform the transformations using R query I can publish the report and schedule a reload. However, if I use R query the reload scheduling asks for a gateway. 

 

I don't use any external data, so, why is there a need for a gateway? 

Why there is no need for a gateway when rendering an R visual and not for running an R query?

 

Thanks in advance.

Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Anonymous,

    When you use R in Query Editor of Power BI Desktop, you are actually accessing on-premises R data source. You can go to File > Options and settings > Data source settings to check that the R data source is added in the PBI file.

    In this case, you would need to install personal model gateway on the machine where  R is installed in order to  access R for data to updated. For more details, please review this article.

    And there is a similar thread for your reference.
    https://community.powerbi.com/t5/Integrations-with-Files-and/Refresh-Failed/m-p/479130#M18742

    Regards,
    Lydia

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Anonymous,

    When you use R in Query Editor of Power BI Desktop, you are actually accessing on-premises R data source. You can go to File > Options and settings > Data source settings to check that the R data source is added in the PBI file.

    In this case, you would need to install personal model gateway on the machine where  R is installed in order to  access R for data to updated. For more details, please review this article.

    And there is a similar thread for your reference.
    https://community.powerbi.com/t5/Integrations-with-Files-and/Refresh-Failed/m-p/479130#M18742

    Regards,
    Lydia

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Thank you very much for the info Lydia.

       

      One thing I don't totally understand is why the visualisation side doesn't need an R gateway and the query part does.

      Is there any idea or any developent roadmap in which the option of integrating R query "natively" (without a gateway) is cosidered?

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Anonymous,

        You should have used R packages that Power BI Service supported in your R visual. Thus, it doens't require access to local R service and gateway is not required in this case. See supported R packages in Power BI Service in the article below.

         https://docs.microsoft.com/en-us/power-bi/service-r-visuals

        Regards,
        Lydia