published report using r source file for creating visuals

[Anonymous]

Hello,

I have a report created locally with R and PowerBI desktop.

In this report, I generate some plots by running R code from my computer. This means that in the "R script editor" I simply have a line like: "source("C:/Users/Myself/PowerBI/Script_Plot01.r")"

Now I want to publish this report. I have the 'pro' license, so it shouldn't be a problem...but I don't know 'where' to put the r code file to be available to PowerBI.

I have tried to link the source with a folder in Sharepoint, so having a line like: "source(" https:// myself. sharepoint.com /PowerBI /Script_Plot01.r  ")"

But it doesn't work. I got the following "Script Runtime Error":

Error in file(filename, "r", encoding = encoding) : cannot open the connection

In addition: Warning message: In file(filename, "r", encoding = encoding) : InternetOpenUrl failed: 'The server name or address could not be resolved'

I found a similar question back to 2018, but was not solved:

 https://community.powerbi.com/t5/Service/Published-R-reports-with-sourced-scripts/td-p/426422

Any help will be appreciated.

Thanks!

[v-lionel-msft]

Hi @Anonymous ,

If you want to use R scripts to create visuals in Power BI, you need to do this.

Create Power BI visuals using R 

If you want to import dataset using R scripts, you need to do this.

Run R scripts in Power BI Desktop 

Use R in Power Query Editor 

Power BI does not support directly importing R script files from the local.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Lionel, thanks for your reply, but it doesn't answer my question.

[DavisBI]

Hi，

Why don't you put the R code directly in the editor of the R custom-visual, but have a separate one on SharePoint?

[Anonymous]

Hi Davis,

I use the same code for multiple visuals. I keep improving/changing the code, and if its only 1 file, it would be much more easier to trace changes and be sure everything is updated.

When you said 'a separate one' you meant a copy?

Thanks

Susana.

[DavisBI]

Got you. You can try to place your .R file locally instead of SharePoint, and then check to see if the problem persists, so you can locate where the problem is. I have tested on my local machine and shared folder, everything is going well.

[Anonymous]

Hello again,

I'm sorry but I don't understand your proposal.

I have tried 3 options:

1) Having the code in a "totally" local path in the visual code. That is "C:/MyCode/script.r"

2) Having the code ina shared folder by Microsoft Teams but saved in my computer. But then, the code in the PBI visual is a local path as above: "C:/MyTeamsFiles/TeamName/PBI/script.r"

3) Having the code in a shared folder in sharepoint and setting http path within the visual. That is: "http:// myself. sharepoint.com /PowerBI /Script_Plot01.r  ")"

None of them worked when I published the PBI file.

If you meant something different by 'shared folder', please provide more details on how to implement it.

Many thanks,

Susana.