Forum Discussion

DannyVos93's avatar
DannyVos93
Regular Visitor
1 year ago
Solved

Table visual object not displaying data on columns

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 column...
  • v-hjannapu's avatar
    v-hjannapu
    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

  • DannyVos93's avatar
    DannyVos93
    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!