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
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 ?¿