Table visual not displaying data in desktop

[paultaylor006]

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?

[v-yiruan-msft]

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 Version

Connect to SQL with Import mode in Power BI Desktop

Best Regards