Automatic data refresh from sharepoint when importing data with R

[TobiasHolm]

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?

[TobiasHolm]

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.

[lbendlin · Accepted solution]

As soon as you "enable load" it counts as a data source (partition). Disable load to make it an expression.

[lbendlin]

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.