Deleting rows with errors on Power BI

Question

I got a query that is returning a row with an error.I've already tried these options, but none of them work:&nbsp; &nbsp; &nbsp;&nbsp;&nbsp; &nbsp; &nbsp;&nbsp;&nbsp; &nbsp; &nbsp;&nbsp;Is there any other solution?

arul · Answer

MahatmaQuijano&nbsp;,What is the error message that you are getting?

mahatmaquijano · Answer

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

arul · Answer

MahatmaQuijano&nbsp;,then you have to check your schema like whether you are missing columns etc.,Please refer the below link you will get some idea on this issue.https://community.powerbi.com/t5/Desktop/how-to-resolve-Power-BI-error-the-key-didn-t-match-any-rows-in/m-p/820063&nbsp;https://community.powerbi.com/t5/Desktop/Expression-Error-The-key-didn-t-match-any-rows-in-the-table/m-p/155986&nbsp;&nbsp;Thanks,Arul

Forum Discussion

Deleting rows with errors on Power BI

3 Replies

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

Related content

Power BI Service error

Refresh Error in Power Bi

Power BI file deleted from SharePoint folder

Cannot delete a workspace. Error: ExistingMangedEndpointsPreventingWorkspaceSoftDeletion

Can't delete Fabric items no Delete option available