Home Business Intelligence Find out how to Disable Present Customized Visible in Energy BI Desktop

Find out how to Disable Present Customized Visible in Energy BI Desktop

0
Find out how to Disable Present Customized Visible in Energy BI Desktop

[ad_1]

Replace Sep 2022: I wrote this blogpost in Mar 2016. Energy BI Desktop improved lots since then. At present, Energy BI Directors can Allow or Disable customized visuals for the reviews printed to Energy BI Service from Energy BI Admin Portal throughout the organisation or to sure safety teams. There are additionally some settings for system directors to Allow or Disable customized visuals on the person’s Energy BI Desktop throughout the organisation by way of group coverage settings. The customers may take away customized visuals from Energy BI Desktop by following these steps:

  1. Clicking the ellipsis button on the Visuals pane
  2. Clicking Take away a visible
  3. Choosing the customized visible
  4. Clicking the Take away button
Removing Custom Visuals From Power BI Desktop
Eradicating Customized Visuals From Energy BI Desktop

Disclaimer: The strategy described on this submit consists of modifying Energy BI file (PBIX) exterior of Energy BI Desktop. It’s extremely really helpful to take a backup of your PBIX file beforehand. It’s extremely possible that you simply corrupt your PBIX file if make a mistake when following the strategy described right here. So please comply with the method on YOUR OWN RISK!

Customized visuals are superior. It’s straightforward to import them to Energy BI Desktop mannequin and begin utilizing them. However, what if you happen to resolve to take away them out of your mannequin? Is there a method to disable an imported customized visible?

Nicely, the reply is No and Sure! I imply, NO, there isn’t a particular setting or possibility you’ll be able to handle imported customized visuals in Energy BI Desktop. However, YES, there’s a approach you’ll be able to do away with an present customized visible. On this article I present you do the job.

To start with, I’d like to tell you that Microsoft will add the function to disable customized visuals in Energy BI Desktop, however, till then you’ll be able to comply with the my trick to fully disable/take away a customized visible out of your Energy BI Desktop mannequin.

As you may already know a PBIX file is a compressed file certainly, so you’ll be able to open it with a ZIP editor software program like 7-Zip.

  • Obtain and set up 7-Zip. It’s a free open supply file archiver/compressor
  • Obtain and set up Notepad++ which can be free and open supply. It’s an superior textual content editor
  • Open you Energy BI Desktop mannequin (PBIX file) containing a customized visible
  • As you see you should allow customized visuals, click on “Allow customized visuals”
Enable Custom Vizuals
  • I used “KPIStatusWithHistory” customized visible in my pattern mannequin
Custom Vizuals

  • As a brand new KPI visible launched by Microsoft I don’t want the customized visible anymore. So I exchange the “KPIStatusWithHistory” with the “KPI” visible.
KPI Vizual
  • In your case you may need to do the identical otherwise you may need to fully take away the customized visible out of your mannequin
  • Save the mannequin after making the corresponding modifications
  • Shut Energy BI Desktop
  • Reopen the PBIX file
  • As you see you though you changed/eliminated the customized visible you continue to get the “Allow customized visible” warning message on high of the report
Enable Custom Vizuals Warning
  • The explanation for that’s that Energy BI Desktop imports the customized visuals to the mannequin, so though we changed the customized visible with a default visible, we nonetheless get the warning message on high of the report. So we have to take away the customized visible from the mannequin
  • Shut Energy BI Desktop
  • Browse the folder containing the PBIX file
  • Proper click on the PBIX file
  • Click on 7-Zip –> Open archive to open the PBIX in 7-Zip
Open PBIX in 7-Zip
  • Double click on “Report” folder
  • Proper click on on “CustomVisuals” folder then delete
Edit PBIX in 7-Zip
  • Now double click on on “Structure” file to open it
  • Home windows will ask you open the file you choose Notepad++
Edit Layout in Notepad++
  • On Notepad++ click on “View” menu then tick “Phrase wrap” to see the file content material tidier
Edit Layout in Notepad++ 2
  • Press “Ctrl + F” to open “Discover”
  • Seek for ,”resourcepackages” with out RED citation marks
Edit Layout in Notepad++ 3
  • Choose ,”resourcePackages”:[ and whole text after it down to close bracket. If you use Notepad++ it’s easy to find the close bracket as it highlights it. You can also search for ,”sections”: and you can find the close bracket right before it. 
Modifying Layout Scripts
  • Delete the selected text
  • “Save as” the “Layout” file in your local drive
  • Remember that the “layout” file doesn’t have any file extension. So if Notepad++ added a default text file extension when saving  remember to remove it
  • Now drag and drop the file to 7-Zip and replace the existing “Layout” file with the new one
Replace Layout
  • Close 7-Zip
  • Open the PBIX file
Disable Custom Visual

As you can see we successfully removed the custom visual from the visualisations. We also got rid of the “Enable custom visual” warning message on top of the report.

Note: You might think of changing the file extension from PBIX to ZIP then open the file normally in Window Explorer. It would be OK for the first part of the job explained so far, but, you might corrupt the file if when replacing “Layout” when browsing the ZIP file with Windows Explorer.

Note: I used 7-Zip with default compression settings. If you change the compression level to anything other than “Normal” it’s highly probable that you corrupt the PBIX structure. Therefore you won’t be able to open it again. This process can also be done using native Windows zip file explorer.

[ad_2]

LEAVE A REPLY

Please enter your comment!
Please enter your name here