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

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.