JSON file doesn't load anymore after january update PBI

[marjoleinnn68]

Since the new update certain JSON files with Themes in it doesn't load anaymore. I would love to know if this is a temporary bug, or a permanent change we have to addapt.

I get this message:

Unable to import theme, There's a problem with your report theme JSON file. 

#/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)

[marjoleinnn68 · Accepted solution]

Thanks again everybody for your help. We finally found the solution here, https://lnkd.in/evMGwfgR, and it works fine again!!

see also  https://www.linkedin.com/posts/marjoleinopsteegh_powerbi-happyendusers-dashboarddesign-activity-7290... 

[tate]

Any idea/help @rohit1991 how to fix the first error lines I got:

#/visualStyles/*/*/title/0/subtitle 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/subtitle must have required property 'reverseDirection' (required; matching schema #/required)
#/visualStyles/*/*/title/0/subtitle must have required property 'hideText' (required; matching schema #/required)

I assume the subtitle problem relates to this part of the scheme:

  "visualStyles": {

    "*": {

      "*": {

        "title": [

          {

            "show": true,

            "fontFamily": "Arial",

            "fontSize": 12,

            "bold": true,

            "fontColor": {

              "solid": {

                "color": "#151515"

              }

            },

            "subtitle": {

              "show": true,

              "fontFamily": "Arial",

              "fontSize": 10,

              "alignment": "left",

              "fontColor": {

                "solid": {

                  "color": "#4F4F4F"

                }

              }

            },

            "background": {

              "solid": {

                "color": "#FFFFFF"

              }

            },

            "alignment": "left",

            "spacing": 5

          }

        ],

I have the latest Nov 2024 report schema file and Visal Studio Code as editor, but I couldn't yet figure it out how to fix those problems as JSON is not that familiar to me

[rohit1991]

Based on the screenshot of your JSON file and the reported errors, you need to make adjustments to ensure compliance with the required schema. Here’s how to fix it:

Updated JSON Fix:

In your subtitle section, include the missing properties and ensure no extra properties are added:
"subtitle": {
"show": true,
"fontFamily": "Arial",
"fontSize": 10,
"alignment": "left",
"fontColor": {
"solid": {
"color": "#4F4F4F"
}},"reverseDirection": false, // Add this property
"hideText": false // Add this property

}

[tate]

Yeah, it fixed those two problems. At the same time I don't get it why this "title test" JSON file, which I made with the help of power bi tips (https://themes.powerbi.tips/themes/wireframes), works just fine without "reverseDirection" and "hideText" - lines:

{

  "name": "Title test",

  "visualStyles": {

    "*": {

      "*": {

        "title": [

          {

            "alignment": "left",

            "background": {

              "solid": {

                "color": "#FFFFFF"

              }

            },

            "bold": true,

            "fontColor": {

              "solid": {

                "color": "#4F4F4F"

              }

            },

            "fontFamily": "Arial",

            "fontSize": 12,

            "show": true

          }

        ],

        "subTitle": [

          {

            "alignment": "left",

            "fontColor": {

              "solid": {

                "color": "#4F4F4F"

              }

            },

            "fontFamily": "Arial",

            "fontSize": 10

          }

        ]

      }

    }

  }

}

[marjoleinnn68]

Thank you all for your comments, 

but,

the question is not how to solve this error messages,

but,

does anybody know if there is a bug or an updat in power BI that causes trouble in loading JSON files into Power BI?

I first need to know the cause of the problem. This happened " overnight", I didn't have amy troubles before. I'm not a JSon specialist so it is hard to understand all the answers above. Before i dive in, i first need to know if it is a temporary bug, or a new situation to handle.

And if so, what are the new rules so it won't happen again. 

[v-yaningy-msft]

Hi, @marjoleinnn68 

Thanks for the reply from rohit1991 and tate. You can try their method to solve the problem temporarily, if their response is of some help to your current problem, you can accept it as a solution, which will help people with similar problems find answers.For this problem is the update appears temporary or permanent change, in the current update file does not see for the JSON file aspect of the information, so can not be sure, thank you for your understanding. However, if you're a Power BI Pro or Fabric licensee, you can create a support ticket for free and a dedicated Microsoft engineer will come to your home and fix the problem for you. The link of Power BI Support: Microsoft Fabric Support and Status | Microsoft Fabric 

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[rohit1991]

Your JSON works without reverseDirection and hideText because Power BI applies default values (false for both). These properties are optional and only needed for specific functionalities like reversing bar chart directions or hiding text. Since your design doesn’t require them, the file remains functional and clean.

[tate]

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
Also this post seems to have the same problem: https://community.fabric.microsoft.com/t5/Desktop/For-Power-BI-themes-we-use-a-customed-JSON-file-bu...