Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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 November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors