Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hello Everyone,
I have been trying to perform text analysis using R and PowerBI, but one particular package - Sentimentr keeps giving me errors.
I am using PowerBI desktop to run an R transformation using Sentimentr to create Sentiment scores for a text in the dataset.
However, the moment I run the R-Code, I am presented with an error DataFormat.Error: ENVSXP without any specific information on what might have caused the error.
Can you please help with understanding what might be wrong or how to circumvent the error for Sentiment results ?
Please note that while I am using PowerBI Desktop (August 2021 release), the code runs perfectly in R-Studio. Additionally, Sentimentr package is fully supported by PowerBI service to the latest version 2.7.1.
Thank you all for your time and help !
Solved! Go to Solution.
Hi @Anonymous ,
Please follow this document to check whether you applied correct steps to run R script in the newest Power BI desktop.
Best Regards,
Kelly
Did I answer your question? Mark my reply as a solution!
@Anonymous This has come up before, check this thread: Re: Error in running an R script using sentimentr ... - Microsoft Power BI Community
Thank you ! I did check the thread, but I think a resolution was not reached to the problem. The only other comment at that time (2019) was that the package was not supported by PowerBI, however, the package is now supported. Yet the problem still exists in the running the package through PowerBI.
Hi @Anonymous ,
Please follow this document to check whether you applied correct steps to run R script in the newest Power BI desktop.
Best Regards,
Kelly
Did I answer your question? Mark my reply as a solution!
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 39 | |
| 37 | |
| 33 | |
| 32 | |
| 29 |
| User | Count |
|---|---|
| 132 | |
| 88 | |
| 82 | |
| 68 | |
| 64 |