Forum Discussion

JamesW_TSC's avatar
JamesW_TSC
Regular Visitor
5 years ago

Tables disappearing in Service

Hi All,   I have a very strange issue that appears to be cache related but I've cleared cache multiple times and still have the same issue. The Desktop and the service data sets are both refreshed ...
Need Help
steven__h's avatar
steven__h
New Member
5 years ago

This is getting more bizarre. It's totally related to our custom theme that we apply to our company reports.

It's now happening on any report I open that uses this theme.

It also happens in incognito mode and even when I log in from an entirely separate machine!?!

Is there some sort of theme cache on the powerbi app service?

steven__h's avatar
steven__h
New Member
5 years ago

Just in case anyone else hits this issue... it seems that the custom theme on our report had a JSON data in it that only caused issues on the online powerbi service.

 

The area in question was in the visualStyles node for all attributes (*). A fontColor had two values in an array, instead of a singular value:

 

{
   "name": "DOESN'T WORK ONLINE",
   "background": "#CCCCCC",
   "foreground": "#FFFFFF",
   "tableAccent": "#FFFFFF",
   "visualStyles": {
      "*": {
         "*": {		
            "*": [
               {
                  "fontSize": 10,
                  "fontColor": [
                     {"solid": {"color": "#000000"}},
                     {"solid": {"color": "#000000"}}
                  ],
                  ...

The chunk above has been shortened ... there's a lot more fluff surrounding it.

Either way, that fontColor should be singular:

"*": [
               {
                  "fontSize": 10,
                  "fontColor": {"solid": {"color": "#000000"}},
                  "labelColor": {"solid": {"color": "#000000"}},
                  "color": {"solid": {}},
                  "fontFamily": "Segoe UI",

 

With this change made manually to the exported theme, I then re-imported it and upon upload to PowerBI, it all displayed fine again online.

 

This has worked without an issue for years... it seems today that something has changed in the JSON validation world. And for online only, as it still works fine on the Power BI Desktop app.

 

Hope this can help someone else!