Forum Discussion
Automatic data refresh from sharepoint when importing data with R
I have report where all of the data sources it uses are on Sharepoint.
However, it also imports some data through an R-script, which means I cannot not just automate the refresh like I can in my other reports.
While all the data the R-script uses is on sharepoint it still does not work.
I assume it is because the data set needs an installation of R to run the script, and such an installation is not present on PBI Service. Is this true, or am I completely off?
If that is the case, can I turn off data refresh for the table from the R-script?
In the Power Query on Power BI Desktop I can tick of the "include in report opdate" or whatever it is called in english, but it does not make a difference after I publish the report to Service. Am I doing something wrong, is there something I am missing or what is going on?
As soon as you "enable load" it counts as a data source (partition). Disable load to make it an expression.
3 Replies
I assume it is because the data set needs an installation of R to run the script, and such an installation is not present on PBI Service. Is this true, or am I completely off?True-ish. For R script refreshes on the Power BI service you MUST use a PERSONAL (not enterprise) gateway.
That makes sense. In that case I would like for the table depending on R to not update with everything else when I schedule a data refresh in PBI service.
From what I can read online this should be a simple toggle in PBI desktop, however it still wants to join scheduled refreshes in PBI service.
I have toggled the "include in report refresh" off, and published the report and dataset again, but it doesn't change anything.
Do you have any idea why that might be?
I do not use the values in the tabel directly for visuals, I use them as parameters for multiple measures and calculated columns.As soon as you "enable load" it counts as a data source (partition). Disable load to make it an expression.
