Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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.
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.
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.
@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.
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.
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
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
Hide in Report View is not selected.
Thanks for the suggestion though. It's a strange issue.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |