Don't miss your chance to take exam DP-600 or DP-700 on us!
Request nowLearn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
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
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Check out the February 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 54 | |
| 47 | |
| 39 | |
| 16 | |
| 15 |
| User | Count |
|---|---|
| 83 | |
| 70 | |
| 38 | |
| 28 | |
| 27 |