Forum Discussion

alks_skla_f's avatar
alks_skla_f
Helper II
11 months ago
Solved

Table visual is empty

Hello,

I have a table "hst_grdf_TEMP":

When I choose table visual and click on columns, nothing appears:

 

  • Hi alks_skla_f 

    Could you please try below steps:


    1. Fresh test: Create a new page << add a Table visual << drop in 2 columns. If rows show here, the old page was over-filtered.

    2. Clear filters: In the old page, open the Filters pane and click the eraser on all filters (visual, page, report). Also check Format << Edit interactions so every slicer is set to Filter, not None.

    3. Turn off role view: Go to Modeling << View as and set to None (RLS can hide rows).

    4. Check relationships: In Model view, temporarily set related links to Inactive. If rows appear, fix the join (same data type, no extra spaces, matching case) and keep it 1<<*, single direction.

    5. Visual basics: Use a Table visual, not Matrix. Place fields in Values only. Remove any Top N or “is not blank” filters.

6 Replies

  • Hi alks_skla_f 

    Could you please try below steps:


    1. Fresh test: Create a new page << add a Table visual << drop in 2 columns. If rows show here, the old page was over-filtered.

    2. Clear filters: In the old page, open the Filters pane and click the eraser on all filters (visual, page, report). Also check Format << Edit interactions so every slicer is set to Filter, not None.

    3. Turn off role view: Go to Modeling << View as and set to None (RLS can hide rows).

    4. Check relationships: In Model view, temporarily set related links to Inactive. If rows appear, fix the join (same data type, no extra spaces, matching case) and keep it 1<<*, single direction.

    5. Visual basics: Use a Table visual, not Matrix. Place fields in Values only. Remove any Top N or “is not blank” filters.

  • Hello alks_skla_f 

     

    You would need to provide more info for other users to investigate.

     

    For example, what's on your filter panel? Also hover over the filter icon on top right of your visual and see what filters have been applied to this visual. I also see a 'Back' button on the page, is there a Bookmark on the report? 


    Thanks. 

     

  • Shahid12523's avatar
    Shahid12523
    Community Champion

    Make sure hst_grdf_TEMP has data (check in Data view).
    Drag columns into the table visual manually, not just tick them.
    Clear filters that might be hiding rows.
    Confirm the table is loaded to the model (check Power Query).
    Check data types — unsupported types won’t show.

  • v-aatheeque's avatar
    v-aatheeque
    Community Support

    Hi  alks_skla_f 

     

    We haven’t heard from you on the last response and was just checking back to see if your query was answered, Otherwise, will respond back with the more details and we will try to help .

    • v-aatheeque's avatar
      v-aatheeque
      Community Support

      Hi alks_skla_f 

      We’d like to check if you were able to go through the previous response to your issue. Please let us know if you need further clarification we’ll do our best to support you.

      • v-aatheeque's avatar
        v-aatheeque
        Community Support

        Hi alks_skla_f 

        We’d like to check if you were able to go through the previous response to your issue. Please let us know if you need further clarification we’ll do our best to support you.