Table visual object not displaying data on columns

[DannyVos93]

Hello everyone,

I need help with something, so we have a table that must contain 17 columns. All the columns are coming from one query, they have data and the data is valid. There are text columns, numbered columns, calculated columns with text or numbers, etc.

The problem we have is that when we add all the columns, the data for some of them start to disappear randomly, even though on the query a value exists, on the table it appears blank.

We have tried removing all the fields, and adding them back, and reordering them, some of the data came up, but other disappeared. All the relationships are correct and working as expected as well.

We are curious as to what may be causing this behaviour. Could it be that the table is overloaded? Or it may be related to the fields order? Has anyone come across something like this?

Any help is appreciated!

[v-hjannapu · Accepted solution]

Hi @DannyVos93  ,

Thanks for the update.
you are using OData and the data is fine in the query but disappears in the table visual, it seems like a rendering issue due to too many columns.
To fix this, try splitting the table into two visuals with fewer columns each or create a new table visual and add columns one by one to see which one causes the issue. Also, check if the column data types are set correctly in the model view. You can use the Performance Analyzer in the View tab to check if the visual is slowing down.

if you are still facing issue , we will help you to resolve it
If this helps, please accept as a solution and give a kudos so that other members can easily find it .

Regards,
Harshitha

[DannyVos93]

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.

[v-hjannapu · Accepted solution]

Hi @DannyVos93  ,

Thanks for the update.
you are using OData and the data is fine in the query but disappears in the table visual, it seems like a rendering issue due to too many columns.
To fix this, try splitting the table into two visuals with fewer columns each or create a new table visual and add columns one by one to see which one causes the issue. Also, check if the column data types are set correctly in the model view. You can use the Performance Analyzer in the View tab to check if the visual is slowing down.

if you are still facing issue , we will help you to resolve it
If this helps, please accept as a solution and give a kudos so that other members can easily find it .

Regards,
Harshitha

[v-hjannapu]

Hi @DannyVos93,

Just wanted to check if you had the opportunity to review the suggestion provided?

If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank You.

Harshitha.

[v-hjannapu]

Hi @DannyVos93 ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please Accept it as a solution so that other community members can find it easily.

Thank you.

[v-hjannapu]

Hi @DannyVos93,

May I ask if you have resolved this issue? If so, please mark the helpful reply and Accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[DannyVos93 · Accepted solution]

Hi there, I'm sorry I couldn't get back to you guys earlier. 

We finally solved it. What we did was that we rebuilt the whole table visual and we realized that for the fields we were entering on the table, we were sometimes aggregating them (showing as sum, or average) and other times we would put them as dont't summary. After we left all the fileds as Don't summarize, and as Show items with no data, the information would all be displayed as expected and no missing data points were identified.

Thank you for the help troubleshooting this!

[v-hjannapu]

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.

[Elena_Kalina]

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.

[burakkaragoz]

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