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

[manjeshjk]

Hi All,

I am getting the following error , Expression.Error: The key didn't match any rows in the table.

1) I added a table (RPA_GATEPASS) from my Oracle database and it accepts and got added to the data model.

2) When I try to add the complete string, since this is required for me to access the data through gateway

When I click the edit settings then this following dialog box appears and here I am not able to find the table name RPA_GATEPASS, somehow this view is not refreshed or it  is having some old snapshot. I cannot see many of the new tables that I created in the last couple of days ago.

 The power bi desktop version is

Anybody facing issue like this, or any feedback/suggestions are welcome.

Regards,

Manjesh

[v-rongtiep-msft]

Hi @manjeshjk ,

Difficult to say without actually seeing your  query or knowing what you data looks like, but if removing the  query makes the error disappear then you should check your Oracle database .

Run the uery against the database directly and see if itworks.

I have also found some posts, please refer to them to see if them  help you.

Solved: Processing error: The key didn't match any rows in... - Microsoft Power BI Community

Solved: An error occurred in the ‘Transform File’ query. E... - Microsoft Power BI Community

Solved: Error upon refresh (The key didn't match any rows ... - Microsoft Power BI Community

If it still does not help, please provide more details with the error.

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[manjeshjk]

Hello @v-rongtiep-msft ,

The issue is that, if I select some old tables from the same schema then there is no issue. I believe that the snapshot is not getting refreshed and the newer tables are not seen by Power BI.

Is there a possibility that I can check with an expert from Microsoft PowerBI team.

Regards,

Manjesh

[v-rongtiep-msft]

Hi @manjeshjk ,

You can  open a ticket here for help if you are a pro user:

Support | Microsoft Power BI

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.