How can we improve Power BI?

Export current theme as a Json file

We have a wonderful option - switch theme to import theme as a JSON file.It would be great to have an export option to export current theme as a JSON file from a report.

290 votes
Sign in
(thinking…)
Password icon
Signed in as (Sign out)

We’ll send you updates on this idea

Siva Mani shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

20 comments

Sign in
(thinking…)
Password icon
Signed in as (Sign out)
Submitting...
  • Ryan commented  ·   ·  Flag as inappropriate

    Thank you Anonymous! It worked for me as well.

    "Anonymous commented · October 05, 2017 17:41
    Nice to have for the lazy people. But think of your pbix file as a zip file. Simply rename, unzip and extract your json ;-) Works for me."

  • Anonymous commented  ·   ·  Flag as inappropriate

    If you can import it then you should be able to export it...don't see why it wasn't in the original design.

  • Larissa commented  ·   ·  Flag as inappropriate

    This is a great idea and I have so much use for the potential of this option.

  • B D commented  ·   ·  Flag as inappropriate

    I am struggling with 12 pie charts I have and I have to show same 5 columns in different numbers and to show a different custom colours' theme than default for each of them with a single colour profile is proving a challenge. Power BI is turning to be headache any sort of advanced reporting. Been working with many tools for 9 years and this is the first time a tool proves to be a problem than rather being a solution.

  • Jed Hansen commented  ·   ·  Flag as inappropriate

    Even if it is not possible to export the configuration for all visuals as a single theme, at least create the ability to export JSON from single visuals which could be collated into your preferred default Theme. Working 'backwards' from existing JSON syntax is easier and it makes working on smaller portions easier, as well.

    Using the .zip hack works, but, exporting the configurations from individual visuals in JSON would be a better solution and would allow for mixing and matching from different theme 'parts'.

  • Alex Xavier commented  ·   ·  Flag as inappropriate

    This would be great. I would like to see this feature as a "Bake Current Theme" option that allows us to save the JSON file wherever we want to and I would like it if the bakes theme picked the first visual of each type in the current file and created the format based on the options in that item. As well as page options, data colors, etc. A stretch goal would be for pre assigned data colors, so that if I assign "USA" as blue and "Russia" as red before I bake the file the theme would save that preference and assign the colors to their respective values

  • Victor Vink commented  ·   ·  Flag as inappropriate

    Would we wonderful to have this, and makes it easier to roll out standard formats / colors and reporting themes throughout the organization and in organization style

  • John commented  ·   ·  Flag as inappropriate

    changing to .zip file and getting .json theme did not transfer changes made to tables, such as grid lines on and color black.

  • EJG commented  ·   ·  Flag as inappropriate

    This is very important to organization where there is dedicated visual specialist responsible for look and feel of PowerBI reports. We want to be able to export/import theme (including layout). Thanks

  • Anonymous commented  ·   ·  Flag as inappropriate

    Thank you Anonymous... worked for me too!!! :-)

    "Anonymous commented · October 05, 2017 17:41 · Flag as inappropriate
    Nice to have for the lazy people. But think of your pbix file as a zip file. Simply rename, unzip and extract your json ;-) Works for me."

  • Adam Bäckman commented  ·   ·  Flag as inappropriate

    This is a must have for enterprise development and quite strange that it hasn't been done given the very good talk that was given at the summit about gestalt principles. Right now I spend an inordinate amount of time aligning formatting across pages and reports to ensure a consistent user experience.

  • Anonymous commented  ·   ·  Flag as inappropriate

    Nice to have for the lazy people. But think of your pbix file as a zip file. Simply rename, unzip and extract your json ;-) Works for me.

  • Ello commented  ·   ·  Flag as inappropriate

    It would be great if the JSON file could be exported from a PBIX file. Then it is possible to create 1 file with all the customization we want for a specific report and export that one and use it in all the other reports. That would save use al lot of time since creating the json file is not straight forward.

  • CLE commented  ·   ·  Flag as inappropriate

    Yes - It will bee excelent if we could export a json file after we have designed
    our own Theme in Power BI .

  • ElliotP commented  ·   ·  Flag as inappropriate

    Would be incredibly handy for large scale ISV developers who want to ensure colour and visual consistency. At the moment, selecting the right colours/visual options takes up a greater amount of time than putting together the visuals (a testament to how amazing powerbi is that we are at this point)

  • edh commented  ·   ·  Flag as inappropriate

    This is even more important now that the theme file is more than just colors. Would be handy to set up key visuals as I like, then export the json file without having to manually create it.

Feedback and Knowledge Base

Ready to get started?

Try new features of Power BI today by signing up and learn more about our powerful suite of apps.