Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Full Data Not Showing in Table

Using PowerBI Desktop, I'm experiencing issues with the table visualization. It is currently not showing the full set of data which is about 36,000+ rows in one and 450,000+ rows in the other. I have "Do not summarize" selected for each column. 

Need Help

8 Replies

  • Wilson_'s avatar
    Wilson_
    Memorable Member
    2 years ago

    Hi m_white,

     

    My first question is why are you trying to show a table with 36k+ or 450k+ rows in Power BI in the first place?

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      I work for a large company that holds massive sets of data. I don't need it to show all on one page. I need it to be in a table that I can scroll through but for some reason, it's cutting the data off.

      • Wilson_'s avatar
        Wilson_
        Memorable Member
        2 years ago

        You're saying you need to be in a table you can scroll through... but why? What purpose does this serve? What analytical value does this have?

  • PijushRoy's avatar
    PijushRoy
    Community Champion
    2 years ago

    Hi Anonymous 

    Please right-click on the field in the visual and select "Show Item with no data"

     


    Let me know if that works for you


    If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the Thumbs Up 👍 button if this comment helps you.

    Thanks
    Pijush
    Linkedin

    • PijushRoy's avatar
      PijushRoy
      Community Champion
      2 years ago

      Hi Anonymous 

      Please right-click on the field in the visual and select "Show Item with no data"

       


      Let me know if that works for you


      If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the Thumbs Up 👍 button if this comment helps you.

      Thanks
      Pijush
      Linkedin

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Anonymous 

     

    There are several factors and limitations to consider:

    1. Power BI Visualization Limits

    Direct Query vs. Import Mode: If you're using DirectQuery mode for your data source, remember that Power BI has limitations on the amount of data that can be displayed in a single visual to ensure performance. 

    Visual Rendering Limits: Power BI Desktop may impose limits on the number of rows displayed in a table visual to ensure optimal performance and user experience. For very large datasets, it's recommended to use filters, slicers, or aggregations to focus on specific subsets of data.

    2. Data Model and Relationships

    Ensure that your data model is optimized and that relationships between tables (if your visualization relies on data from multiple tables) are correctly set up. Misconfigured relationships can lead to missing or incomplete data in visuals.

    3. Filtering and Slicers

    Check if there are any filters, slicers, or other visuals on the report page that might be inadvertently filtering out data from the table visual. Page-level or report-level filters can restrict the data displayed in visuals, including tables.

     

     

     

    Best Regards,

    Jayleny

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.