Power BI Missing Data in Some Columns from Local SQL Database

[aaronbest_]

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

[ankitpatira · Accepted 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