Linked Dashboard Filters Not Working Between Entity ID and Text Field Despite Correct Foreign Key Setup

I have a database where:

  • organizations_region.organization_id is correctly set as a foreign key to organizations_organization.id
  • organizations_organization.id has its Display value set to name in the data model
  • Data model settings are synced, visibility is "Everywhere", and types are correctly configured

However, when I:

  • Use a Field Filter variable for organization_id (ID field) and name (Text field)
  • And link them in a dashboard using dynamic filters (e.g., "Region Name is limited by Organization ID")

I get errors like:

“There was a problem displaying this chart”
or the filter does not populate dropdown values correctly.

This only fails for Entity ID to Text linked filters — while similar Text → Text linked filters (like City → State) work as expected.

First step is to look in the logs to see what error is being thrown.