Data weird behavior

[Mumin192]

Hello,

I'm importing data from PostgreSQL and having a very strange behavior

The table has user_id, date, some more columns

For some reason, looks like it's connecting user_id to wrong rest of information

For example a user_id = 20908, when I check the database, the date should be 13/10/2022, but when I import data, the date for this user_id would be 03/10/2022, with the rest of information is wrong as well

But, if I filter to this specific user_id in power query, date would become 13/10/2022 as well as the rest of information

I'm not doing any steps on power query. Any idea why this is happening?

Thanks

[AntrikshSharma]

@Mumin192 Could be an issue of persistent cache that is save on disk for quick viewing of the data, try to refresh the whole query and see if everything is fine.

For example let's say you previously loaded a query that is connected to a SQL view, just add a new column into that view and then create a new query to that view you will see the new column doesn't appear, you can even perform filters on rows and the column will not appear, it only appears once you refresh the cache. 

[Mumin192]

I cleared cache and still same results

[Waldo35]

both screenshots like 13-10 to me.

Usually when something goes from 13 to 3 or something like that it means the formatting is incorrect. So it thinks the 13 is a month while it's actually a day. But it tries to correct the 13, so it makes it 3, a viable month. I feel like PowerBI is smart enough to understand the translation tho.

Sample of usual european data format (i also think it changes based on selected power bi language)

[Mumin192]

I don't think it's the date format

I even imported data as text and had the same results

Even the rest of details are different, as if it's linking user_id with a totally different row details