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
GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
5 years ago
Why not copy this report to another App Workspace, then download that copy and see if that works?
steven__h's avatar
steven__h
New Member
5 years ago

Howdy,

 

First thing I tried was to upload again as a different file-name to the existing workspace. Same issue.

I then uploaded to my own personal workspace, same issue.

I downloaded that file from my personal and the tables show fine in desktop.

 

Note that this report has worked fine for two weeks.

This morning I went to edit it online in the original location to adjust a few page filters (not on the pages with tables) and then all tables magically disappeared.

 

It seems that updating via the web has trashed the table visibility and no amount of editing or changing table themes will fix it!

  • 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!

  • 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?