Replace Sep 2022: I wrote this blogpost in Mar 2016. Energy BI Desktop improved so much since then. At present, Energy BI Directors can Allow or Disable customized visuals for the studies 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 consumer’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:
- Clicking the ellipsis button on the Visuals pane
- Clicking Take away a visible
- Deciding on the customized visible
- Clicking the Take away button
Disclaimer: The strategy described on this submit contains modifying Energy BI file (PBIX) outdoors of Energy BI Desktop. It’s extremely advisable to take a backup of your PBIX file beforehand. It’s extremely possible that you just corrupt your PBIX file if make a mistake when following the strategy described right here. So please observe 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 should you determine to take away them out of your mannequin? Is there a technique to disable an imported customized visible?
Properly, the reply is No and Sure! I imply, NO, there is no such thing as a particular setting or possibility you possibly can handle imported customized visuals in Energy BI Desktop. However, YES, there’s a manner you possibly can do away with an present customized visible. On this article I present you find out how to 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 possibly can observe the my trick to utterly disable/take away a customized visible out of your Energy BI Desktop mannequin.
As you would possibly already know a PBIX file is a compressed file certainly, so you possibly can 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 also 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”
- I used “KPIStatusWithHistory” customized visible in my pattern mannequin
- 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.
- In your case you would possibly wish to do the identical otherwise you would possibly wish to utterly 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
- The rationale 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
- Double click on “Report” folder
- Proper click on on “CustomVisuals” folder then delete
- Now double click on on “Structure” file to open it
- Home windows will ask you find out how to open the file you choose Notepad++
- On Notepad++ click on “View” menu then tick “Phrase wrap” to see the file content material tidier
- Press “Ctrl + F” to open “Discover”
- Seek for “,”resourcepackages”” with out RED citation marks
- 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.
- 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
- Close 7-Zip
- Open the PBIX file
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.