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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. 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)

6 REPLIES 6
samueloliver
Frequent Visitor

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

Anonymous
Not applicable

Hi @samueloliver 

It is happy that you have solved your problem, you can accept your answer as a solution so that more user can refer to.

 

Best Regards!

Yolo Zhu

unfortunately it didn't work for everything it's only wroking for the existing reports, not if your building a new report!

 

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.

I have similar situation. Please help me fix the issue. The JSON theme file is throwing an error after the update. Find JSON below the error. 

ERROR:
#/visualStyles/*/*/title/0/color 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/*/*/title/0/color must have required property 'reverseDirection' (required; matching schema #/required)
#/visualStyles/*/*/title/0/color must have required property 'hideText' (required; matching schema #/required)
#/visualStyles/*/*/title/0/color must NOT have additional properties (additionalProperties; matching schema #/additionalProperties)
#/visualStyles/*/*/title/0/color/solid must have required property 'color' (required; matching schema #/oneOf/0/properties/solid/required)
#/visualStyles/*/*/title/0/color must have required property 'gradient' (required; matching schema #/oneOf/1/required)
#/visualStyles/*/*/title/0/color must NOT have additional properties (additionalProperties; matching schema #/oneOf/1/additionalProperties)
#/visualStyles/*/*/title/0/color must have required property 'pattern' (required; matching schema #/oneOf/2/required)
#/visualStyles/*/*/title/0/color must NOT have additional properties (additionalProperties; matching schema #/oneOf/2/additionalProperties)
#/visualStyles/*/*/title/0/color must match exactly one schema in oneOf (oneOf; matching schema #/oneOf)
#/visualStyles/*/*/title/0/color must have required property 'linearGradient2' (required; matching schema #/oneOf/0/required)
#/visualStyles/*/*/title/0/color must NOT have additional properties (additionalProperties; matching schema #/oneOf/0/additionalProperties)
#/visualStyles/*/*/title/0/color must have required property 'linearGradient3' (required; matching schema #/oneOf/1/required)
#/visualStyles/*/*/title/0/color must NOT have additional properties (additionalProperties; matching schema #/oneOf/1/additionalProperties)
#/visualStyles/*/*/title/0/color must match exactly one schema in oneOf (oneOf; matching schema #/oneOf)
#/visualStyles/*/*/title/0/color must NOT have additional properties (additionalProperties; matching schema #/definitions/icon/additionalProperties)
#/visualStyles/*/*/title/0/color must have required property 'name' (required; matching schema #/definitions/image/required)
#/visualStyles/*/*/title/0/color must have required property 'url' (required; matching schema #/definitions/image/required)
#/visualStyles/*/*/title/0/color must NOT have additional properties (additionalProperties; matching schema #/definitions/image/additionalProperties)
#/visualStyles/*/*/title/0/color must be array (type; matching schema #/type)
#/visualStyles/*/*/title/0/color must have required property 'byReference' (required; matching schema #/definitions/itemLocation/required)
#/visualStyles/*/*/title/0/color must NOT have additional properties (additionalProperties; matching schema #/definitions/itemLocation/additionalProperties)
#/visualStyles/*/*/title/0/color must have required property 'text' (required; matching schema #/definitions/annotationTemplate/oneOf/0/required)
#/visualStyles/*/*/title/0/color must NOT have additional properties (additionalProperties; matching schema #/definitions/annotationTemplate/oneOf/0/additionalProperties)
#/visualStyles/*/*/title/0/color must have required property 'color' (required; matching schema #/definitions/annotationTemplate/oneOf/1/required)
#/visualStyles/*/*/title/0/color must NOT have additional properties (additionalProperties; matching schema #/definitions/annotationTemplate/oneOf/1/additionalProperties)
#/visualStyles/*/*/title/0/color must match exactly one schema in oneOf (oneOf; matching schema #/definitions/annotationTemplate/oneOf)
#/visualStyles/*/*/title/0/color must match a schema in anyOf (anyOf; matching schema #/properties/visualStyles/additionalProperties/properties/*/patternProperties/%5E.%2B%24/items/patternProperties/%5E.%2B%24/anyOf)

JSON:
{
"name": "ABCD",
"visualStyles": {
"*": {
"*": {
"title": [
{
"fontSize": 18,
"fontFamily": "Calibri",
"color": {
"solid": {

}
}
}
],
"outspacePane": [
{
"foregroundColor": {
"solid": {
"color": "#051B33"
}
}
}
],
"filterCard": [
{
"$id": "Applied",
"backgroundColor": {
"solid": {
"color": "#D9D7CB"
}
},
"transparency": 0
},
{
"$id": "Available",
"foregroundColor": {
"solid": {
"color": "#051B33"
}
}
}
]
}
}
},
"dataColors": [
"#1F468B",
"#76D2F7",
"#E3ED77",
"#852E85",
"#96C306",
"#D4CDA5",
"#8CC8D9",
"#005F2C"
],
"foreground": "#051B33",
"background": "#FFFFFF",
"foregroundNeutralSecondary": "#051B33",
"backgroundLight": "#4C787D",
"foregroundNeutralTertiary": "#ABA7A2",
"backgroundNeutral": "#C6C2BE",
"tableAccent": "#118DFF",
"maximum": "#C0DB6A",
"center": "#ADE4FA",
"minimum": "#B682B6",
"bad": "#852E85",
"neutral": "#9B8FBB",
"good": "#005F2C",
"textClasses": {
"title": {
"fontFace": "Calibri",
"color": "#263B8C",
"fontSize": 20
},
"label": {
"fontFace": "Calibri",
"color": "#051B33",
"fontSize": 12
},
"callout": {
"fontFace": "Calibri",
"color": "#263B8C",
"fontSize": 36
},
"header": {
"fontFace": "Calibri",
"color": "#263B8C",
"fontSize": 28
}
}
}

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
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

May 2025 Monthly Update

Fabric Community Update - May 2025

Find out what's new and trending in the Fabric community.