Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
I have Power BI Desktop connected to an local MS SQL server. Most of the data is pulling file, however some feilding in some columns is missing.
For example: In my SQL database I have the following data:
But when I look in Power BI I get this:
Other data appears to be queried correctly
Solved! Go to Solution.
@aaronbest_ Few ways you can check if there's an issue,
1. go to data view in power bi desktop by clicking on Data view on left hand side and check all data is there or not
2. Check data in table visual and ensure you have Don't summarize for all the fields you've dropped on table visual
3. Ensure correct data type has been applied in power bi desktop to each columns
4. Query SQL Server data source explicitly for those columns by typing in sql query
@aaronbest_ Few ways you can check if there's an issue,
1. go to data view in power bi desktop by clicking on Data view on left hand side and check all data is there or not
2. Check data in table visual and ensure you have Don't summarize for all the fields you've dropped on table visual
3. Ensure correct data type has been applied in power bi desktop to each columns
4. Query SQL Server data source explicitly for those columns by typing in sql query
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 158 | |
| 132 | |
| 116 | |
| 79 | |
| 54 |