Data source error: Expression.Error: The key didn't match any rows in the table + OneLake Security
Hi All,
I am receiving this error when trying to refresh a model in the service. Locally it refreshes just fine. Connected to the table (Table1) in my lakehouse via the SQL Endpoint.
The configuration:
Entra group: GroupA
OneLake Security Role: RoleA
Table Name: Table1
The onelake security RoleA has been given access to Table1 and the member of that RoleA is GroupA.
They can see the table in the UI both in the lakehouse in the SQL Endpoint and can query it fine. The lakehouse is configured to use Onelake security (user identity mode).
I have confirmed the gateway cloud connection to the lakehouse has the GroupA added as a user and configured that in the semantic model settings - but we still receive this error.
Did I miss something in my configuration?