Forum Discussion

rajasekar_o's avatar
rajasekar_o
Helper V
2 years ago

scheduled refresh error

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?

 

 

3 Replies

  • mussaenda's avatar
    mussaenda
    Community Champion

    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's avatar
      rajasekar_o
      Helper V

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

       

      • mussaenda's avatar
        mussaenda
        Community Champion

        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?