Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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)
I work together with marjoleinnn68 and she has the solution for our problem solved with json editor tool
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!
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.
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.
Missing Stuff: Certain required properties like reverseDirection, hideText, solid, gradient, and pattern are missing in some parts of your JSON.
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.
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.
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
}
}
}
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...
User | Count |
---|---|
84 | |
74 | |
63 | |
51 | |
45 |
User | Count |
---|---|
101 | |
43 | |
41 | |
39 | |
36 |