Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hello,
I can't use the R script editor in Power Query. Even with a very simple code like this one :
test<-dataset
test$newcolumn<-1
I have the following problem :
DataSource.Error : ADO.NET : Ä ρѓóвľэм θć¢ŭѓяеð ẃђїľë ρřόćєšśίňğ ўòŭř Γ šĉřϊφŧ.
Ħзѓє ăґë тĥё ţέċћпїсåľ đ℮ţαīľś: [DataFormat.Error] Désolé... Nous ne pouvons pas procéder à la conversion en un nombre.
Détails :
DataSourceKind=R
DataSourcePath=R
Message=Ä ρѓóвľэм θć¢ŭѓяеð ẃђїľë ρřόćєšśίňğ ўòŭř Γ šĉřϊφŧ.
Ħзѓє ăґë тĥё ţέċћпїсåľ đ℮ţαīľś: [DataFormat.Error] Désolé... Nous ne pouvons pas procéder à la conversion en un nombre.
ErrorCode=-2147467259
ExceptionType=Microsoft.PowerBI.Scripting.R.Exceptions.RUnexpectedException
However, I use R visuals in Power Bi without any problem. Do you have any idea what the problem is?
Solved! Go to Solution.
Hi , @Jeremy19
According to your error message, you seem to have encountered a problem with the data conversion format when using R script, I think you can first follow this official document to check whether your local computer is completely configured for the R script environment, and check whether you have encountered any restrictions:
Use R in Power Query Editor - Power BI | Microsoft Learn
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Thank you I have reproduced the example on my data with this code which works :
library(readxl)
dataset<- read_excel("D:/Event.xlsx")
output<-dataset
output$test<-1
I still have a problem, locally it works but my data source is an online Excel on Sharepoint. Do I have to do a read_excel() in the R script? How to do it with a web link. The error tells me that the path does not exist
Hi , @Jeremy19
For your question, as searched , you can refer to this that hope to help you:
Accessing Excel file from Sharepoint with R - Stack Overflow
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi , @Jeremy19
According to your error message, you seem to have encountered a problem with the data conversion format when using R script, I think you can first follow this official document to check whether your local computer is completely configured for the R script environment, and check whether you have encountered any restrictions:
Use R in Power Query Editor - Power BI | Microsoft Learn
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
77 | |
72 | |
56 | |
40 | |
35 |
User | Count |
---|---|
71 | |
65 | |
57 | |
49 | |
47 |