Forum Discussion
Missing first and last row
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.
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.
4 Replies
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.
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
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
Please provide the details of your steps and the filtering you apply on your data
