Failed to apply query: The key did not match any rows in the table.

[renatohonorio]

Hello community.

I started assembling a dashboard by obtaining data from the PostgreSQL database. The connection was established through the ODBC driver and it worked correctly with the data being loaded. But when trying to apply a fixed query within the power query, the tool is returning the following message: "The key did not match any rows in the table."

Informed query:

Reply:

Does anyone know how to solve?

Thanks!

[lazurens2]

You are probably adressing a database object that named differently. 
Have a look at this : 

https://community.powerbi.com/t5/Desktop/Expression-Error-The-key-didn-t-match-any-rows-in-the-table...