Forum Discussion
writetofaiz
Helper I
2 years agoValues not coming in the filter.
Hi,
In Power Query, I got the below result when I filtered the existing query by certain service code.
Then I removed the service code filter from the query and I got the full dataset. Now when I tried searching for any of the values listed above, I don't see the result. What can be the reason for it and how I can fix this issue?
writetofaiz , Try number filter , Then equals to and enter your value, I think it is because your data preview is set to 1000 rows
2 Replies
- bhanu_gautam
Super User
writetofaiz , Try number filter , Then equals to and enter your value, I think it is because your data preview is set to 1000 rows
- writetofaiz
Helper I
Thanks it worked.