Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
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
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 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...
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
97 | |
65 | |
45 | |
39 | |
31 |
User | Count |
---|---|
164 | |
111 | |
61 | |
53 | |
38 |