Table Data Not Visible in Desktop

[Anonymous]

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?

[Anonymous · Accepted solution]

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.

[Icey]

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]

@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]

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.

[aswin_k]

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

[amitchandak]

I hope you have not clicked "Hide in report view" By mistake.

Please check by right-clicking the table in the Model view.

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.

My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

[Anonymous]

Hi @amitchandak @aswin_k 

Hide in Report View is not selected. 

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