Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Error During Data Refresh

I am receiving the following error wupon refresh of my data,

 

Expression.Error:  The key didn't match any rows in the table.

 

Upon closer inspection, when I Go To Error, I am told:

 

Expression.Error: The key didn't match any rows in the table.
Details:
Key=Record
Table=Table 

 

Anyone have a solution to this?

 

Thanks.

Need Help
Show and Tell

12 Replies

  • MarcelBeug's avatar
    MarcelBeug
    Community Champion
    9 years ago

    Probably you have a navigation table with the objects from your input; the object that was selected when the query was created (or last updated) doesn't exist any more.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      MarcelBeug

       

      Can you further explain your thoughts...not sure what it is that you are suggesting, or how to correct it.

      • MarcelBeug's avatar
        MarcelBeug
        Community Champion
        9 years ago

        I can not provide specific comments due to lack of informarion from your side.

         

        Maybe you can explain in more detail what you are trying to and exactly at which point you get the error?

         

         

  • Rozana's avatar
    Rozana
    New Member
    8 years ago

    Hi 

     

    I am receiving the follwoing error when I try and refresh my data:

     

    Load was cancelled by an error in loading a previous table.

     

    What should I do?Noting that I had no problems before but this suddenly happened

     

    Thanks in advance for your support

      • Rozana's avatar
        Rozana
        New Member
        8 years ago

        Yes, there was no problem at all. When any problem happened before, it directly fixed after fixing the excel sheet. But now I couldn’t find any error