Disclaimer: The tactic described on this submit consists of modifying Energy BI file (PBIX) exterior of Energy BI Desktop. It’s extremely really useful 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 comply with the method on YOUR OWN RISK!
Customized visuals are superior. It’s simple to import them to Energy BI Desktop mannequin and begin utilizing them. However, what in case you resolve to take away them out of your mannequin? Is there a strategy 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 choice you may handle imported customized visuals in Energy BI Desktop. However, YES, there’s a means you may do away with an present customized visible. On this article I present you how one can do the job.
To start with, I’d like to tell you that Microsoft will add the characteristic to disable customized visuals in Energy BI Desktop, however, till then you may comply with the my trick to fully 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 may 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 could 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 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
- 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 “Format” file to open it
- Home windows will ask you how one can 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.
