Power BI error that is replacing dates from query view to data view

[KiFa]

I have imported data into power bi from excel. Everything appears fine in the query view, but when I go into the data view, the dates have literally changed. Instead of being a random assortment of dates that are associated with each row, each row now has the exact same date. I have no idea how this is happening. All I have done is apply changes and the date is showing up different.

This is the query view:

This is the data view:

Can someone please help?

[az38 · Accepted solution]

@KiFa 

Power Query is only preview of data. So, first option is to make sure you have no such rows in your data source

[KiFa]

You gave me an idea. It was the sorting.