Forum Discussion
Table visual object not displaying data on columns
- 1 year ago
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 - 1 year ago
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!
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:
Resource Limits: Complex tables (many columns/rows) require significant resources ā Power BI may skip data to prevent freezing
Progressive Loading: For large datasets, Power BI loads data gradually ā some values may temporarily disappear
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.