Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Table visual not displaying data in desktop

Hi folks


Some of my table visuals have stopped displaying data in the desktop version, although when I publish to the service the data is there as normal. In desktop the table just displays as below.




Where this is happening, the visual header that is usually diplayed in the format visual pain next to general is also missing (see below). 




I don't think I have changed any config settings so not sure where the issue is. This is an import query linking to an SQL dataset.


Any ideas?


Community Support
Community Support

Hi @paultaylor006 ,

If I understand correctly, the table visuals in your report can display in Service normally. But they can't display normally in Power BI Desktop, and there is no Visual tab in Format pane. Am I right? What's the version of your Power BI Desktop? Could you please update the version of your Power BI Desktop to the latestone one if it still be the older version.

Download Center page


I can't reproduce your problem with Power BI Desktop latest version (Version: 2.115.842.0 64-bit (March 2023)).

My Power BI Desktop VersionMy Power BI Desktop Version

Connect to SQL with Import mode in Power BI DesktopConnect to SQL with Import mode in Power BI Desktop

Best Regards

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors