I had an issue where I imported a SQL server dataset to Power BI Desktop, and I tried to make a Table visual out of three different fields from a table that my dataset has.
Also, my dataset table has some records with a NULL value but when I look at the Power BI visual table that I generated I see that those records deleted automaticaly!
So, how could I stop Power BI from doing that and let it include all the records that my dataset table have and let power BI view it exactly like how it appears in SQL server.
I attached a pic shows the missing records from Power BI table visual versus SQL server dataset table.
Click drop down arrow next to field you dropped in values in tables visual and select "Show Items with no data"
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Helpful resources
Power BI Monthly Update - November 2025
Check out the November 2025 Power BI update to learn about new features.
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
