Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
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/
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.