Power Query doesn't match Power Bi Table view

Hey CESTX,

I had faced the similar issue a while ago.

Here's what fixed it.

Looking at your screenshots, this appears to be a common Power BI date formatting/display issue. Here are the key steps to resolve this:

1. Check Data Types in Power Query

• Go to Power Query Editor
• Verify both date columns are set to "Date" data type (not Text or DateTime)
• If they're Text, convert them using Date.FromText() function

2. Verify SQL Source Data

• Check if the SQL source has any NULL values or invalid dates
• Look for dates like '1899-12-30' which often indicate data quality issues
• Consider filtering out these problematic dates at source

3. Refresh and Clear Cache

• Close Power BI completely
• Reopen and refresh the dataset
• Sometimes cached data causes display inconsistencies

4. Column Settings Check

• In Power Query, right-click the Promised Delivery Date column
• Check "Column quality" and "Column distribution" for any errors
• Look for data type mismatches or parsing errors

5. Model View Verification

• Go to Model view in Power BI
• Check the data type of both columns in the Fields pane
• Ensure they're both marked as Date, not Text

Please note: - 

The blue highlighted date (30-december-1899) is likely a default date from SQL when there's a NULL or conversion error. Focus on cleaning the source data and ensuring proper data types throughout the pipeline.


Did it work? ✔ Give a Kudo • Mark as Solution – help others too!