Table Preview Text Not Showing up in Power BI App

[seabrew]

Starting today for all of the reports I publish using the table preview, the column/row text is not visable, however the grand total text is visable. If I switch the table back to the "non-preview" version, the text appears. I tried in multiple browsers. Also, I do see the Alt Text / tooltip when I hover over the missing row. 

Can anyone reproduce this?

[v-ljerr-msft · Accepted solution]

Hi @seabrew,

As we cannot reproduce the same issue on out environment, I would suggest you create a support ticket on Power BI Support page for better assistance on this issue. 

Regards

[GilbertQ]

I tried it on one of my reports with a table preview and I can see all the data in the tables fine.

[seabrew]

Do you have the newest build of Power BI Desktop? I was prompted to update today. I had June 2017 already, but went from version 2.47.4766.542 to 2.47.4766.801. I wonder if the desktop build is the issue. 

[seabrew]

I confirmed that this problem is limited to a single pbix report and pages. I can not reproduce the issue in a new pbix file. Does anyone know what to do if a PBIX file is corrupted like this? The problem persists even in new pages. 

Can I fix it? I would hate to have to rebuild the data model again!

[blindeye]

The latest Power BI Desktop version appears to have caused some problems with the way exising tables are processed in Service - similar issue here http://community.powerbi.com/t5/Service/Style-quot-Matrix-Preview-quot-visuals-is-changed-by-PBI-Ser... - in my case I immediately noticed the formatting had changed in Service, and when trying to edit, the visual has been converted from the table preview to a matrix

[seabrew]

I noticed the same thing mentioned in your link when I added a table. In Desktop the rows did not alternate in colors, yet in the service they were alternating row. I fixed this by toggling a different table style, then going back to None, and republishing. 

I ended up repurposing the "corrupted" .pbix and using it only as shared data model. I needed to make the switch to having the data model exist separately anyways. New .pbix files using the PowerBI Service connect are displaying the table preview correctly. 

I hope MSFT gets this fixed soon!

[v-ljerr-msft · Accepted solution]

Hi @seabrew,

As we cannot reproduce the same issue on out environment, I would suggest you create a support ticket on Power BI Support page for better assistance on this issue. 

Regards

[seabrew · Accepted solution]

I found the reason I was having this issue and I have to say I am a bit embarassed. Shortly before I posted this question, I had created a custom JSON theme and had #FFFFFF (i.e. white) set as the foreground and tableAccent colors.

So what was really happening is that the default font color in the matrix/table was set to white against a white background. 

Hopefully someone else who makes these same mistake comes across this post before they start pulling their hair out!

[seabrew]

Ok, thank you! I'll do that. 

[seabrew]

Ok, thank you! I'll do that. 

[seabrew]

I confirmed that this problem is limited to my pbix report and pages. Does anyone know what to do if a PBIX file is corrupted like this? The problem persists even in new pages. 

Can I fix it? I would hate to have to rebuild the data model again!

[seabrew]

Ok, thanks for checking. Weird. Hopefully it resolves itself for me.