Power BI - R Visuals passing Filter values

[JithinSankar]

I've been trying out some Power BI R integration samples. So far, everything works fine interms of Passing the dataset , getting the plots from R and displaying them in Power BI, Slicing the Visuals based on Related Filters in Power BI. 

Here's the Problem,

1. Is there a way to pass an unrelated value in the Dataset to R Script? 

  This Variable is used in a section of my R script (as an a parameter to a function but not to restrict the dataset)  and the user should have the ability to change it from the front end in Power BI.

Has anyone done this? 

[Anonymous]

Hi @JithinSankar ,

Did you get any solution for this please, I'm also on the same page.

I want to pass data into R script though the Power BI filters.

Regards,

[BeardyGeorge]

not tried it myself (yet ,it's on the list), but I suspect this should give you the basic tools you need to do what you're after (the read.table and write.table bit) - there may be some security concerns with this though, so think carefully before you do it with any confidental data.

[JithinSankar]

BeardyGeorge, Thanks for the link.

I am doing a bit of Read / Write in my R script but what I'm after is a far simpler issue. Lets say you want to give an option to the user to view a dataset on a monthly Aggregate or Daily Aggregate (kinda like a switch).

I'm thinking of a Variable (Qlikview ,OBIEE have got them) that the user can select and that can be passed on to R.

 Idea: Allow Users to Create Variables in Power BI