Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Table Data Not Visible in Desktop

Hello,

 

I have a table that was showing up in Desktop, but now all fields are invisible. The data is still there, because I can create visuals. The data for that table is visible in Power Query. I don't think the file is corrupt, because the data is still working. 

 

I've tried:

Restarting Desktop

Deleting and reconnecting

Opening a new file and starting fresh (exact same issue as descriptions above)

Clearing the Cache

 

Any suggestions?

Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    I figured this one out. There were a bunch of null value lines in my table for some reason, and they were all filtered to show first on the table. Once I filtered the null values in Power Query, the issue was corrected. 

     

    Updating in the event someone else finds this helpful.

7 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    I figured this one out. There were a bunch of null value lines in my table for some reason, and they were all filtered to show first on the table. Once I filtered the null values in Power Query, the issue was corrected. 

     

    Updating in the event someone else finds this helpful.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi amitchandak Anonymous 

       

      Hide in Report View is not selected. 


      Thanks for the suggestion though. It's a strange issue.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi,
    Check if "Hide in report view" of the table is enabled or not. To see that you can click ellipsis icon on the table.
    Regards
    Aswin

  • Icey's avatar
    Icey
    Community Support
    6 years ago

    Hi Anonymous ,

    I find a similar post: Data Not Showing Up. It was solved just by re-importing datasets. Hope this is helpful.

     

    Best Regards,

    Icey

     

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

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Icey Thanks for the post. 

       

      I've tried reimporting, as well as starting a fresh report, and for some reason the Excel file I'm using continues to show up as blank. 

      • Icey's avatar
        Icey
        Community Support
        6 years ago

        Hi Anonymous ,

        Some suggestions from others:

        1. Try to disable any preview features that you may have enabled.

        2. Try to force the refresh by going to the Data Mode (NOT the "Edit Queries" mode) and right clicking at the TABLE (NOT the general "Refresh" button at Home Menu) and choosing "Refresh".

        3.  Try to create a random column to the table not loading and apply in Power Query.

        4. If all these don't work, maybe you need to reinstall Power BI Desktop.

         

        Refer to this post: Data not Showing up.

         

        Best Regards,

        Icey

         

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