Exporting data set to CSV using R Script failing with error

[kathraji]

Hi there,

I'm trying to export dataset from PowerBI Desktop tp CSV using R Script but when I run it failing with below error. Please help.

DataSource.Error: ADO.NET: A problem occurred while processing your R script.
Here are the technical details: [DataFormat.Error] We reached the end of the buffer.
Details:
DataSourceKind=R
DataSourcePath=R
Message=A problem occurred while processing your R script.
Here are the technical details: [DataFormat.Error] We reached the end of the buffer.
ErrorCode=-2147467259
ExceptionType=Microsoft.PowerBI.Scripting.R.Exceptions.RUnexpectedException

Regards,

Anil Kumar

[Anonymous]

Hi

Silly question, but did you test your script in R Studio First.

I tried the simple code below and it worked.

homework_5 <- read.csv("C:/DIAD/Data/USSales/sales.csv")

Tomas