Missing first and last row

[Robby_WW]

Hello,

Im loading in data from dataverse in query and after applying all the steps needed.

Im getting 2 different results when I apply filters (guid ID's) at the very end or at the start.

result from filters at the end.

when I move the same filter step to start I get this (correct) result

I do not want to use these filters in the query, these are used in the rapport.
at first I thought maybe it reached the row limit but that doesnt appear to be the case.

[Omid_Motamedise]

Please provide the details of your steps and the filtering you apply on your data

[Robby_WW · Accepted solution]

Thanks but I have found the solution.

Problem was with creating unique key value where we then removed double values. They used the wrong column ID. Cause of having a similar name with another ID column.

[Anonymous]

Looks like you've successfully solved the problem, @Robby_WW .

If possible, accept your reply as a solution, and more people will benefit from it.

Best Regards,

Stephen Tao

[PhilipTreacy]

@Robby_WW 

Hard to say without seeing your data and knowing what filter(s) you are applying.

Can you please supply uour file or at least the data (as a table not an image) and show/explain the filter.

Regards

Phil