Export all Power BI built-in themes

From 2019 – December version, Power BI allows to export existing themes as theme files. With this, rather than creating a theme file from the scratch, we can export existing theme and modify according to our requirement. However, if this has few limitations. First, it does not allow to export the default theme. As you can see in below image, if we select “Default” theme, export current theme option is disabled. For all other built-in theme, you can select the theme and then export it. However, this means you need to apply that theme one by on to the report, and then export one at a time.

In this post, I’m going to show you a quick and easy way to export all Power BI themes within a minute. It include exporting the default theme as well.

For that first you need to enable the preview feature : “Store datasets using enhanced metadata format” in Power BI.

More about new Power BI metadata format: https://docs.microsoft.com/en-us/power-bi/desktop-enhanced-dataset-metadata

To enable it, Click “Files” -> “Option and Settings”-> “Options” -> “Preview Features”. Once you enable that preview feature, you might have to restart Power BI to make it effective.

After restating Power BI, create an empty Power BI template file using clicking “Files”-> “Export”-> “Power BI template”. You don’t require to load any data or create any visuals inside your Power BI file for this.

Next, go to the saved “.pbit” file and change it’s extension to .zip. In other words, if your file name is “Demo.pbit” , rename it to “Demo.zip”. Now unzip the file you created and you will see set of files and sub folders inside the extracted folder. Check the image below.

If you go the “..\Report\StaticResources\SharedResources\BuiltInThemes” folder, you will see all the built-in theme files are available inside the folder as JSON files. You can open these files and customize based on your requirement.

If you want to export “Default” theme which is not available from Power BI UI, you can find it inside “..Report\StaticResources\SharedResources\BaseThemes” folder. As shown in the image below, “CY19SU12.json” is the Default theme file and you can modify this file and export back to Power BI as your custom default theme.

Hope this short post help you to play with Power BI themes. Thank you for reading and stay safe! Cheers!!

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s