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:   Expressi...
Need Help
Show and Tell
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

sebasjun's avatar
sebasjun
Helper I
8 years ago

Hello Rozana

 

In the preview mode can you refresh all?

 

Best regards

  • 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 

    • sebasjun's avatar
      sebasjun
      Helper I
      8 years ago

      Hello

       

      If the preview run i think the problem is in the data. 

       

      Try to disable other tables in your model or reduce the numbers of rows, to review.

       

      Can you send the PBIX and Excel to review ?¿