Use Power BI to change R script using parameters

[Ani1991]

Hi Team,

Greetings of the day!!

I am working on a small POC and would appreciate your help with it.

The requirement is, I have a csv file which is imported using Get data in Power BI.
The structure is as follows:

Srno.           Country
1                   India

2                   UK

3                   USA

4                   Germany

Now, same csv is imported in R using read.csv function.

On the Power BI side I have created two parameters "Srno" and "Country". I want to link these two parameters in the Rscript.
I want to have such a scenario that when I provide some values in the parameter that would add up to my csv via the Rscript and then further when I refresh Power BI I should be able to see the newly added values by me. If suppose I provide "5" and "Austria" then the csv file should now have.

Srno.           Country
1                   India

2                   UK

3                   USA

4                   Germany
5                   Austria

I have used rbind to append values to the csv. But how to link the Power BI Parameters with the R script.

I am not pretty sure how to achieve this and hence would require your kind help with this.

KIndly let me know for any more information if required.

Thanks,

Anish

[Ani1991 · Accepted solution]

Hi All,

Thanks.

Was able to figure out the solution for it.

Regards,

Ani

[v-chuncz-msft]

@Ani1991 

Glad to hear that. If you don't mind, just share the solution here. Your contribution is highly appreciated.