Table visual object not displaying data on columns

Hi DannyVos93 ,

Yeah, I've run into this kind of thing before in Power BI, especially with table visuals that have a lot of columns or calculated fields. A couple of things you might want to check:

• Sometimes if you have too many columns, especially with complex calculated columns or measures, Power BI visuals can start acting weird, and some columns might not show up as expected. It’s not always about the number of columns, but more about how heavy the calculations are or if there are any columns producing errors or blanks behind the scenes.
• Try checking if any of your calculated columns/measures are returning blanks or errors for certain rows, even if it looks fine in the query. Sometimes DAX can behave differently in the visual vs. the data view.
• Also, if you’re using DirectQuery, visuals might struggle if the query gets too complex or if column types are mismatched.
• Field order usually shouldn’t matter, but sometimes rearranging them does fix odd glitches, as you’ve noticed. You could also try creating a brand new table visual and add the columns back in slowly to see if there’s a specific column or combination that triggers the issue.
• Lastly, make sure you’re on the latest version of Power BI Desktop—visual bugs do get patched pretty often.

Hope this helps a bit! Would be interested to hear if you find the culprit or if you have a sample file you can share, sometimes that makes it easier to troubleshoot. Good luck!
translation and formatting supported by AI

Hi DannyVos93 

The most likely reason for this behavior is the high number of columns (17). This appears to be a rendering issue - while your data exists in the model, Power BI struggles to display everything in the table visual simultaneously due to performance optimization.

Why This Happens:

1. Resource Limits: Complex tables (many columns/rows) require significant resources → Power BI may skip data to prevent freezing

2. Progressive Loading: For large datasets, Power BI loads data gradually → some values may temporarily disappear

3. Cache Issues: Visuals can get "stuck" displaying outdated cached versions

Try scroll through the table (if data appears during scrolling, it's a rendering issue) or reduce column count (if missing data reappears, this confirms the problem)

I would recommend you try

- move less critical columns to tooltips

- use hierarchical drilling

- implement bookmarks to toggle columns

- split into multiple related tables

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

Thank you.

Hi DannyVos93 ,

Thank you  for reaching out to the Microsoft fabric community forum.
Thank you Elena_Kalina and burakkaragoz  for your response.

Here are a few steps you can try:
1.Check if any calculated columns or measures are returning blanks or errors for specific rows.

2.Try creating a new table visual and add the columns back one by one see if a particular field causes the issue.

3. If you’re using DirectQuery, try switching to Import mode (if possible), as DirectQuery can slow down or limit visuals with many fields.
4.Make sure Power BI Desktop is up to date some visual bugs get fixed in new versions.

5.Check the data types of all columns mismatched or incorrect data types  can affect how data shows in visuals.

6. Clear the visual cache by saving, closing, and reopening the report, or even restarting Power BI to ensure it' not  a temporary glitch.

If this answer was helpful and pointed you in the right direction, please consider accepting it as solution and kindly give a kudos it will benefit other community members in the community. If you have any further questions, feel free to let us know.
Regards,
Harshitha.

Thank you burakkaragoz Elena_Kalina v-hjannapu 

All the information and expertise you have provided is very valuable, me and my team are still troubleshooting this situation and we are following the indications you have shared.

There are just two things I'd like to point out:

• we are not using DirectQuery, the connection to the datasource we have set up is OData (is the only way we have to connect).
• the missing values on the table object do exist in the queries and are correct. The issue arises when we start to add the columns to the table and the values disappear.

we are also considering other table objects to download from the internal catalog but we are not sure.

Thanks again, I'll let you know how it goes.