Forum Discussion
R scripts "Enable script visuals" to "select to enable" and back to enable script visuals loop
Hi Esabee,
What version of power bi desktop are your report works normally before you update to the last version? Did this issue appear on other devices? I'd like to confirm if this is a specified device issue.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
Hi Xiaoxin
Thank you for your response.
I don't think it is a device issue. I have the same device as previously and have not used Power Bi on another device for a very long time (if ever). Since I described the issue here, I have started up a brand new, empty pbix file and I have tested my script in this file. The script works and visualises fine. I have since also checked some older R script visualisations on my device. It looks like the issue only affects all R scripts in this particular dashboard/pbix file.
So therefore it is unlikely to do with the device, and also nothing to do with the PowerBI version.
The only logical possible causes I can think of are that
a) my pbix file was somehow corrupted - possible, but why would it only affect my R script visualisations? All native DAX/Powerquery code visualises fine. Also why do R scripts not work on previous versions of this particular dashboard/pbix I saved? I cannot answer this because I have insufficient understanding of how the software works, but this seems strange to me.
b) an interaction with some of the data or visuals I have added to the dashboard after adding the R scripts - still testing this by bringing in one visual after the other and continuing to test if my R scripts still visualise. So far so good.
c) I may possibly have created an unusual "meta settings" environment by enabling a whole lot of development options one of which (or the interaction of which) may have caused R scripts not to visualise. I am testing this by not enabling any development options other than R scripting and so far I am still able to visualise R scripts as part of the bigger dashboard.
I am partway through rebuilding the data model and dashboard from scratch and will provide feedback should I be able to isolate the issue.
Best wishes
Esabee
Hi Esabee,
#1. Perhaps you can try to use third-party tools to connect to the power bi data model and trace them to confirm if any properties have been broken.
External tools in Power BI Desktop - Power BI | Microsoft Docs
#2. For the interaction, you can turn on the 'edit interactions' UI to simply check the visual interaction statuses:
Change how visuals interact in a report - Power BI | Microsoft Docs
#3. Did you mean the enhanced dataset metadata? If that is the case, they may change the report structure and they may not compatibility with old structures that generated on the old versions. You can also take a look at the following document it helps:
Using enhanced dataset metadata in Power BI Desktop - Power BI | Microsoft Docs
Regards,
Xiaoxin Sheng