cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
sumit591 Frequent Visitor
Frequent Visitor

Data Source with R

I am unable to import excel using R Script in Power BI. 

Below is the code I am trying to execute:

library(readxl)
dataset <- read_excel("C:\\Users\\sumit.gupta5\\Desktop\\Loan.xlsx",sheet = "Sheet1")

and below is the error I am getting:

Details: "Exception of type 'Microsoft.Analytics.Modules.R.ErrorHandling.RException.Primitives.NotValidRDataException' was thrown."

 

Please help !

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Data Source with R

Hi @sumit591 ,

From your description, I'm afraid that your function is incorrect.

df <- read_excel("<name and extension of your file>")

Please refer to this blog which introduce for us how to Reading and Importing Excel Files into R step by step.

Best Regards,

Cherry

 

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 REPLY 1
Community Support Team
Community Support Team

Re: Data Source with R

Hi @sumit591 ,

From your description, I'm afraid that your function is incorrect.

df <- read_excel("<name and extension of your file>")

Please refer to this blog which introduce for us how to Reading and Importing Excel Files into R step by step.

Best Regards,

Cherry

 

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.