Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have an issue when filtering data in power Query editor.
The source files is an odata feed from a time recroding application
When filtered by User Name, User ID or Date (after 01/07/2021 (1st July UK based)) the entries in the query change.
i.e. before filters applied there is a user that has time entered of 22 days on 19th july and 4.28 on 20th July, after filter applied the 19th July entry is duplciated and the 20th July entry is removed. I.e. on visuals days changes from 26.28 to 44.
The same issue occurs when I sort descending by user ID with no filters, i.e. the data changes. This is part of larger performance system but I have stripped down to just single query load and same issue occurs i.e. only a single data table in query so no links or joins that could be messing it up. I am very confused, any assistnace would be greatly appreciated.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.