Forum Discussion
PQO Evaluation Failed
Hi! We are getting this error when we try to save the table. What can we do?
PQO Evaluation Failed
- public.table_name PowerQuery response to return with error message 'The key didn't match any rows in the table.' and errors: 'Microsoft.PowerBI.Cdsa.Common.ExceptionResultError[]
Código de status: 400
Código de Erro: PQO Evaluation Failed
1 Reply
- v-yueyunzh-msft
Community Support
Hi , wallacepaula
Based on the information provided in the retrieved documents, the error message "The key didn't match any rows in the table" is a common error message that can occur when working with Power Query in Power BI.
The error "The key didn't match any rows in the table" means that Power Query cannot find the table name it is looking for. Reasons why this error may happen include is here , you can refer to and check it:
Common Authoring Issues in Power Query - Power Query | Microsoft LearnAt the same time, you also need to check whether each step of each of your queries is causing this error due to some file name changes or column changes.
There are some similar cases, you can also refer to:
Solved: Expression.Error: The key did not match any rows i... - Power Platform Community (microsoft.com)Solved: Expression Error.: The key didn't match any rows i... - Microsoft Fabric Community
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
