scheduled refresh error

[rajasekar_o]

While I am schdule refresh the data I am getting error.

There is no value of id but is shows error during schedule refuresh. 

how to solve this error?

[mussaenda]

Hi @rajasekar_o,

The search you are using is only for the top 1000 rows. 

Use the Number filter instead (above the search bar you are using)

[rajasekar_o]

i search with number filter ,i have the id value one time ,but its shows the same error 

[mussaenda]

You can group your table by id and count the rows to check the duplicate. 

Then remove the group step after you see the culprit.

Better to refresh the data before doing this.

Also, wouldn't it be better if your data type for the id is whole number instead of decimal?