Forum Discussion
Solved
Power Query doesn't match Power Bi Table view
I have this weird issue where the dates in Power Query which get's it's source from SQL doesn't fully match with the dates in Power Bi Table view. As an example, i have filtered and sorted on both s...
The blank fields have in the meantime been filed out by users with actual dates, so at the moment i don't have the issue, i'll try your solution when the issue is back.
Hello CESTX
My speculation is there might be mixed Data types in 'Promised Delicery Data' column in Power Query.
When the data is loaded into Power BI’s model, the column must be entirely of one date type, If even one row is text or improperly typed, Power Bi attempts to coerce it and convert text to date.
You may use AddColumn to run a quick check by
Table.AddColumn(Source, "DataTypeCheck", each Value.Type([Promised Delivery Date]))
Hope this helps:)