Forum Discussion
R Script visual looks different in PowerBI Desktop compared to online (published) report
As the title says, the R Script visuals work properly in Power BI Desktop, but when I publish the report and view it on the Power BI website, the visual is different. Instead of displaying the text which can be found in the data source (I did check to make sure the local and online versions matched), it shows numbers in the comments column. If I download the Power BI file from the website and open it in Power BI Desktop, the visualization is correct.
The code runs properly in R Studio and Power BI Desktop, so I'm very confused as to why the published report is acting this way. I've provided some screenshots of the issue. Any help with this issue is appreciated. Thanks!Power BI Desktop VisualPower BI website visual
2 Replies
Hi joey_russ
So the value in comments is not showing up correctly on Power BI Service, is it ? Can you provide the R Script for reference ?
How to provide sample data in the Power BI Forum - Microsoft Fabric Community
Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Hi Anonymous
Yes, that's right. Everything in Power BI Desktop is correct, but after I publish it, the comments column is different on the Power BI website.
I've provided links to the whole pbix file and the R Script file for the visual on the first page. For the R Script visuals to work in Power BI Desktop, the code at the top of the R Script needs to be run, so the packages "grid" and "gridExtra" are installed. Additionally, I've de-indentified some of the data since none of the information affects the R Script visuals (I also checked to make sure the publication error stills occurs, and it does).
If there's any other information I can provide that would help, let me know. Thanks for your help!
Link to pbix file: https://4csouthernin-my.sharepoint.com/:u:/g/personal/intern_buildingblocks_net/ETgk3kWYHxFPtsFJoxBbJQIBDvH6PxaAvOPQWrY0CAt7GQ?e=kfjscN
Link to R Script file: De-Identified R Script Visual Code (First Page).R
