Connecting both Salesforce and R Script

[jonmak-jon]

I want to create a refresh-able data connection with Salesforce (report) to which R script is applied to transform some columns before the transformed data gets loaded into the report. 

I know I can use on-premise gateway for R script and content pack connection with Salesforce, but how do I combine the both?

[hugoberry]

Most likely you'll be using R.Execute function to do your data wrangling. 

Type the following command in your query to get more details about this

= #shared[R.Execute]

For an instruction on how to call R from the UI you can follow the article from

https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-r-in-query-editor/

Probably the only change you'll have to do is instead of loading CSV, load Salesforce data.

Another good resource

https://blog.gbrueckl.at/2016/05/running-local-scripts-power-bi/

[jonmak-jon]

I want to create a refresh-able data connection with Salesforce (report) to which R script is applied to transform some columns before the transformed data gets loaded into the report. 

I know I can use on-premise gateway for R script and content pack connection with Salesforce, but how do I combine the both?