PBI not adding first 3 lines to RStudio

[MattCrowley]

When I create an R visual with local data queried from Salesforce & Redshift, and then click the "open in RStudio" button. PBI does not add the first 3 lines that load my data.

Given that the folders in under Appdata/local/radio/ use obscure ids, it's really hard to know which is the proper file to load if I wanted to do it manually.

Thoughts?

- Matt

[v-sihou-msft]

@MattCrowley

You need to Run the R file instead of working in console.

The chart will display properly in Rstudio.

Regards, 

[MattCrowley]

Hi, thanks for the response!

What do you mean by "Run"? I have tried clicking the "Run script" button in the PBI script editor before and after clicking "Edit script in external R IDE".

Btw, this is using RStudio 3.3.3 

Steps from a blank page:

1. Add R visual to the page

Result: Script editor opens and is blank because there are no fields

2. Add my 2 fields c_email, u_email to the values field

Result: he script editor populates with the R script to create a dataframe, but the "Run Script" is still grayed out, since no script that actually does anything has been added yet

3. Click "Edit script in external R IDE"

Result: RStudio opens to a blank console window with no data loaded... help files suggest it should load the data set.

OK, so lets rewind a step and try running something first:

3. Add "plot(1)" to the R script editor in PBI

Result: the "Run Script" button is now active

4. Click "Run Script" button in PBI script editor

Result: a plot shows up in the R visual on the PBI page, as expected

5. Click "Edit script in external R IDE"

Result: RStudio opens to a blank console window with no data loaded.

Through all of this, I can see that when I click "Edit script in external R IDE", a folder is created in appdata/local/radio exactly as it should. And when I close the RStudio window the folder is removed. So that seems to be working fine. RStudio just isn't loading the R file in that folder.

I even tried setting the temp folder to a new location to make sure RStudio had access to it. Still doesn't work!