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!

v-hjannapu's avatar
v-hjannapu
Community Support
1 year ago

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.