Starting with R in Power BI

[Anonymous]

Hello, 

I am at my first steps with R in Power BI.  I have installed R Studio 64 bit for windows. Also, I have installed R Open, version R-3.5.3 from Microsoft.

Also, I have load a PBIX to test my installation.

A copy of the project is available at:   https://onedrive.live.com/?authkey=%21AJ1XcXB95pETL2g&cid=CBDD37C1AF373511&id=CBDD37C1AF373511%21307...

The file on OneDrive is a zip file which include a PBIX file, an excel file (College Enrollment All Types of Students 14+),

a csv file (PowerPlants).

There is also another file in the project which is named Iris_Data.  I wrote to the author of the pbix in order to get a copy of this file

at sqlDusty@gmail.com.

If I obtain a copy of those files, it will be possible for me to refresh the dashboard.

If I want to read the csv file using R studio, I use the following script:

library(readr)

PowerPlants <- read_csv("P:/Document/Test/Testing R in Power BI/R Visual PBI data sources/PowerPlants.csv")

This script works in RStudio.

If I goes into Power Query Editor, then I select the query powerplants, the I click on Source, a R script window popup.  I enter exactly the same script and I go this error.

DataSource.Error: ADO.NET: R script error.
Error: 'P:/Document/Test/Testing R in Power BI/R Visual PBI data sources/PowerPlants.csv' does not exist.
Execution halted

Details:
DataSourceKind=R
DataSourcePath=R
Message=R script error.
Error: 'P:/Document/Test/Testing R in Power BI/R Visual PBI data sources/PowerPlants.csv' does not exist.
Execution halted

ErrorCode=-2147467259
ExceptionType=Microsoft.PowerBI.Scripting.R.Exceptions.RScriptRuntimeException

Please note that the first line alone works 

library(readr)  but not the second one

PowerPlants <- read_csv("P:/Document/Test/Testing R in Power BI/R Visual PBI data sources/PowerPlants.csv")

failed

As I am at my first steps in R.  I want to test the installation.  

Does someone know how to solve this issue.

[Icey · Accepted solution]

Hi @Anonymous ,

Based on my test in Power BI Desktop, the R Script works fine for connect to data source using your code. Please check the data source because your error is the data source does not exist.

Best Regards,

Icey

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

[Anonymous]

Hello,

I have made some tests to understand how works R in Power BI.

I have tried the following script which is not working

getwd()
work_dir <-"P:/Document/Test/Testing R in Power BI/R Visual PBI data sources"
setwd(work_dir)
getwd()
PowerPlants3 <- read.csv(file = 'PowerPlants.csv')

First, I found that it is better to use the unix convention to separate Directory and Path.  So we need to replace the back slash for the fore slash . Refer to this web page: https://pc.net/helpcenter/answers/backslash_vs_forward_slash

Also, it seems that R inside of Power BI does not recognize the Windows mapping such as P:

So the poper way to access a csv file on a server is by using a script as below:

work_dir <- "//myserverName/document/Test/Testing R in Power BI/R Visual PBI data sources"
setwd(work_dir)
PowerPlants <- read.csv(file = 'PowerPlants.csv')

[Anonymous]

Hello,

Could it be possible that I have an issue due to the fact that the csv file is located on a server not on my local machine?  If it is the case how do we solve this problem.