Power Bi - Snowflake Connection - Error - Key didn't match to any rows in the table

[Sam75]

I am running into this error of key didn't match to any rows in the table when I try to query from snowflake. I noticed, I cannot see the presentation folder on my Power Bi desktop (when connecting to snowflake). Need Help! thanks!

[v-saisrao-msft]

Hi @Sam75,

We haven’t heard back from you regarding your issue. If it has been resolved, please mark the helpful response as the solution and give a ‘Kudos’ to assist others. If you still need support, let us know.

Thank you.

[v-saisrao-msft]

Hi @Sam75,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-saisrao-msft]

Hi @Sam75,
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.

[v-saisrao-msft · Accepted solution]

Hi @Sam75,

Thank you for reaching out to the Microsoft Fabric Forum Community.

Thanks for sharing the issue! The error message "The key didn't match any rows in the table" typically indicates that Power BI is trying to access a table or column that doesn't exist or isn't accessible. As @amitchandak, mentioned, this can often happen when there’s a mismatch in table or column names, which could be caused by renaming or missing objects in Power Query. 

In Snowflake, access to tables, schemas, and databases is managed through roles. If you’re unable to see the expected presentation folder (likely a schema or database), it could be due to role-based permissions. Even if the object exists in Snowflake, Power BI won’t be able to access or display it unless the role has the proper privileges. Additionally, Snowflake is case-sensitive for object names, so if a table or schema is created with quoted names the reference in Power BI must match exactly, including the casing. 

If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

Thank you. 

[amitchandak]

@Sam75 , this error comes when any of the steps in Power Query contain a name that is not present in the sources. Just check the table and column names used. Something is missing or renamed