Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
samueloliver
Frequent Visitor

For Power BI themes we use a customed JSON file, but it stopped working since the latest update.

We use for all our reports  a custom JSON theme, and this work great. Since the january 2025 update we get a lot of errors. 

#/visualStyles/*/*/page must be array (type; matching schema #/properties/visualStyles/additionalProperties/properties/*/patternProperties/%5E.%2B%24/type)
#/visualStyles/*/*/categoryAxis/0/title must be string,number,boolean (type; matching schema #/properties/visualStyles/additionalProperties/properties/*/patternProperties/%5E.%2B%24/items/patternProperties/%5E.%2B%24/anyOf/0/type)
#/visualStyles/*/*/categoryAxis/0/title must have required property 'reverseDirection' (required; matching schema #/required)
#/visualStyles/*/*/categoryAxis/0/title must have required property 'hideText' (required; matching schema #/required)
#/visualStyles/*/*/categoryAxis/0/title must NOT have additional properties (additionalProperties; matching schema #/additionalProperties)
#/visualStyles/*/*/categoryAxis/0/title must have required property 'solid' (required; matching schema #/oneOf/0/required)
#/visualStyles/*/*/categoryAxis/0/title must NOT have additional properties (additionalProperties; matching schema #/oneOf/0/additionalProperties)
#/visualStyles/*/*/categoryAxis/0/title must have required property 'gradient' (required; matching schema #/oneOf/1/required)
#/visualStyles/*/*/categoryAxis/0/title must NOT have additional properties (additionalProperties; matching schema #/oneOf/1/additionalProperties)
#/visualStyles/*/*/categoryAxis/0/title must have required property 'pattern' (required; matching schema #/oneOf/2/required)
#/visualStyles/*/*/categoryAxis/0/title must NOT have additional properties (additionalProperties; matching schema #/oneOf/2/additionalProperties)
#/visualStyles/*/*/categoryAxis/0/title must match exactly one schema in oneOf (oneOf; matching schema #/oneOf)
#/visualStyles/*/*/categoryAxis/0/title must have required property 'linearGradient2' (required; matching schema #/oneOf/0/required)
#/visualStyles/*/*/categoryAxis/0/title must NOT have additional properties (additionalProperties; matching schema #/oneOf/0/additionalProperties)
#/visualStyles/*/*/categoryAxis/0/title must have required property 'linearGradient3' (required; matching schema #/oneOf/1/required)
#/visualStyles/*/*/categoryAxis/0/title must NOT have additional properties (additionalProperties; matching schema #/oneOf/1/additionalProperties)
#/visualStyles/*/*/categoryAxis/0/title must match exactly one schema in oneOf (oneOf; matching schema #/oneOf)
#/visualStyles/*/*/categoryAxis/0/title must NOT have additional properties (additionalProperties; matching schema #/definitions/icon/additionalProperties)
#/visualStyles/*/*/categoryAxis/0/title must have required property 'name' (required; matching schema #/definitions/image/required)
#/visualStyles/*/*/categoryAxis/0/title must have required property 'url' (required; matching schema #/definitions/image/required)
#/visualStyles/*/*/categoryAxis/0/title must NOT have additional properties (additionalProperties; matching schema #/definitions/image/additionalProperties)
#/visualStyles/*/*/categoryAxis/0/title must be array (type; matching schema #/type)
#/visualStyles/*/*/categoryAxis/0/title must have required property 'byReference' (required; matching schema #/definitions/itemLocation/required)
#/visualStyles/*/*/categoryAxis/0/title must NOT have additional properties (additionalProperties; matching schema #/definitions/itemLocation/additionalProperties)
#/visualStyles/*/*/categoryAxis/0/title must have required property 'text' (required; matching schema #/definitions/annotationTemplate/oneOf/0/required)
#/visualStyles/*/*/categoryAxis/0/title must NOT have additional properties (additionalProperties; matching schema #/definitions/annotationTemplate/oneOf/0/additionalProperties)
#/visualStyles/*/*/categoryAxis/0/title must have required property 'color' (required; matching schema #/definitions/annotationTemplate/oneOf/1/required)
#/visualStyles/*/*/categoryAxis/0/title must NOT have additional properties (additionalProperties; matching schema #/definitions/annotationTemplate/oneOf/1/additionalProperties)
#/visualStyles/*/*/categoryAxis/0/title must match exactly one schema in oneOf (oneOf; matching schema #/definitions/annotationTemplate/oneOf)
#/visualStyles/*/*/categoryAxis/0/title must match a schema in anyOf (anyOf; matching schema #/properties/visualStyles/additionalProperties/properties/*/patternProperties/%5E.%2B%24/items/patternProperties/%5E.%2B%24/anyOf)
#/visualStyles/*/*/valueAxis/0/title must be string,number,boolean (type; matching schema #/properties/visualStyles/additionalProperties/properties/*/patternProperties/%5E.%2B%24/items/patternProperties/%5E.%2B%24/anyOf/0/type)
#/visualStyles/*/*/valueAxis/0/title must have required property 'reverseDirection' (required; matching schema #/required)
#/visualStyles/*/*/valueAxis/0/title must have required property 'hideText' (required; matching schema #/required)
#/visualStyles/*/*/valueAxis/0/title must NOT have additional properties (additionalProperties; matching schema #/additionalProperties)
#/visualStyles/*/*/valueAxis/0/title must have required property 'solid' (required; matching schema #/oneOf/0/required)
#/visualStyles/*/*/valueAxis/0/title must NOT have additional properties (additionalProperties; matching schema #/oneOf/0/additionalProperties)
#/visualStyles/*/*/valueAxis/0/title must have required property 'gradient' (required; matching schema #/oneOf/1/required)
#/visualStyles/*/*/valueAxis/0/title must NOT have additional properties (additionalProperties; matching schema #/oneOf/1/additionalProperties)
#/visualStyles/*/*/valueAxis/0/title must have required property 'pattern' (required; matching schema #/oneOf/2/required)
#/visualStyles/*/*/valueAxis/0/title must NOT have additional properties (additionalProperties; matching schema #/oneOf/2/additionalProperties)
#/visualStyles/*/*/valueAxis/0/title must match exactly one schema in oneOf (oneOf; matching schema #/oneOf)
#/visualStyles/*/*/valueAxis/0/title must have required property 'linearGradient2' (required; matching schema #/oneOf/0/required)
#/visualStyles/*/*/valueAxis/0/title must NOT have additional properties (additionalProperties; matching schema #/oneOf/0/additionalProperties)
#/visualStyles/*/*/valueAxis/0/title must have required property 'linearGradient3' (required; matching schema #/oneOf/1/required)
#/visualStyles/*/*/valueAxis/0/title must NOT have additional properties (additionalProperties; matching schema #/oneOf/1/additionalProperties)
#/visualStyles/*/*/valueAxis/0/title must match exactly one schema in oneOf (oneOf; matching schema #/oneOf)
#/visualStyles/*/*/valueAxis/0/title must NOT have additional properties (additionalProperties; matching schema #/definitions/icon/additionalProperties)
#/visualStyles/*/*/valueAxis/0/title must have required property 'name' (required; matching schema #/definitions/image/required)
#/visualStyles/*/*/valueAxis/0/title must have required property 'url' (required; matching schema #/definitions/image/required)
#/visualStyles/*/*/valueAxis/0/title must NOT have additional properties (additionalProperties; matching schema #/definitions/image/additionalProperties)
#/visualStyles/*/*/valueAxis/0/title must be array (type; matching schema #/type)
#/visualStyles/*/*/valueAxis/0/title must have required property 'byReference' (required; matching schema #/definitions/itemLocation/required)
#/visualStyles/*/*/valueAxis/0/title must NOT have additional properties (additionalProperties; matching schema #/definitions/itemLocation/additionalProperties)
#/visualStyles/*/*/valueAxis/0/title must have required property 'text' (required; matching schema #/definitions/annotationTemplate/oneOf/0/required)
#/visualStyles/*/*/valueAxis/0/title must NOT have additional properties (additionalProperties; matching schema #/definitions/annotationTemplate/oneOf/0/additionalProperties)
#/visualStyles/*/*/valueAxis/0/title must have required property 'color' (required; matching schema #/definitions/annotationTemplate/oneOf/1/required)
#/visualStyles/*/*/valueAxis/0/title must NOT have additional properties (additionalProperties; matching schema #/definitions/annotationTemplate/oneOf/1/additionalProperties)
#/visualStyles/*/*/valueAxis/0/title must match exactly one schema in oneOf (oneOf; matching schema #/definitions/annotationTemplate/oneOf)
#/visualStyles/*/*/valueAxis/0/title must match a schema in anyOf (anyOf; matching schema #/properties/visualStyles/additionalProperties/properties/*/patternProperties/%5E.%2B%24/items/patternProperties/%5E.%2B%24/anyOf)

3 REPLIES 3
samueloliver
Frequent Visitor

I work together with marjoleinnn68  and she has the solution for our problem solved with json editor tool

rohit1991
Super User
Super User

Hi @samueloliver , Looks like the recent Power BI update messed with how your custom JSON theme works. Based on the errors you're seeing, it seems like the structure of the theme doesn’t match the new requirements. Here is a list of issues according to the above errors.

  1. Type Issues: Some properties (like page) need to be an array but aren’t. The title property under categoryAxis and valueAxis needs to be a simple value like a string, number, or boolean, but something’s off there too.

  2. Missing Stuff: Certain required properties like reverseDirection, hideText, solid, gradient, and pattern are missing in some parts of your JSON.

  3. Extra Stuff That Shouldn’t Be There: There are properties in your JSON that Power BI doesn’t recognize anymore, so they’re throwing errors.

  4. Schema Mismatch: For some parts, like title, Power BI wants it to fit one specific structure, but your file might have too much going on or be slightly off.

 

Clean Up Your JSON

Here’s what to look for:

  • Fix Property Types: Make sure things like page are arrays and title is a string, number, or boolean.

  • Add Missing Properties: If Power BI says it needs properties like reverseDirection or solid, add them in.

  • Remove Extras: Delete any properties that Power BI doesn’t seem to like anymore.

Here’s a quick example of what a fixed section might look like:

{
"visualStyles": {
"*": {
"*": {
"categoryAxis": [
{
"title": "Example Title",
"reverseDirection": false,
"hideText": false,
"solid": true,
"gradient": null
}],
"valueAxis": [
{
"title": "Value Axis Example",
"reverseDirection": false,
"hideText": true,
"solid": true
}]}}}}



If this doesent work out, you can share the json file itself and we can definitely take on from there.

tate
Frequent Visitor

I have the exact same problem discussed in this thread and looking for a solution: https://community.fabric.microsoft.com/t5/Desktop/Unable-to-import-theme/td-p/4364882
This post seems to have also the same problem: https://community.fabric.microsoft.com/t5/Desktop/JSON-file-doesn-t-load-anymore-after-january-updat... 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.