Filter Only Displays IDs Until Navigating Tabs on Dashboard with Multiple Data Models

Get Help
1

Hello everyone,

I'm experiencing an issue with a dashboard in Metabase (v0.49.13) and would appreciate any insights or solutions you might have.

Dashboard Setup:

  • Dashboard Structure:
    • The dashboard contains 5 tabs:
      1. Report (Weekly)
      2. Report
      3. Points of Interest
      4. Events
      5. Versions
  • Common Filter:
    • All tabs share a single filter named "Device".
  • Data Models and Tables:
    • Tables Used:
      • Event table
      • Device table
    • Data Models Used:
      1. Report Data Model (built from the Event table)
      2. Version Data Model (also built from the Event table)

Details:

  • Event Table:
    • Contains a column named device_id.
  • Device Table:
    • Contains an id column, which is the primary key.
    • The id in the Device table corresponds to device_id in the Event table.
  • Data Model Metadata:
    • In both data models, device_id is set as a foreign key pointing to the Device table.
  • Filter Configuration:
    • The "Device" filter is linked to the device_id column.
    • Intended to display device names alongside their IDs.

Issue Description:

  • When I first open the dashboard and go to the Report (Weekly) tab, the "Device" filter dropdown only displays device IDs (e.g., 123, 456), without the associated device names.
  • If I navigate to the Versions tab and then return to the Report (Weekly) tab, the "Device" filter starts displaying device names along with their IDs (e.g., Device A (123), Device B (456)).
  • This issue seems to occur only on the initial load of the dashboard.

What I've Tried:

  • Verified that device_id is correctly set as a foreign key in both data models.
  • Confirmed that the filter is properly linked to the device_id column.
  • Checked for any discrepancies in the setup between the Report (Weekly) and Versions tabs.

Questions:

  1. Why does the "Device" filter only show IDs upon the initial load and not the device names?
  2. Why does navigating to the Versions tab and back resolve the issue temporarily?
  3. How can I make the filter display device names consistently without needing to switch tabs?

Additional Information:

  • Metabase Version: v0.49.13
  • Both data models are based on the Event table and have the foreign key relationship to the Device table defined in their metadata.
  • The issue affects all tabs that use the Report Data Model but not the tab that uses the Version Data Model.

Any insights or suggestions on how to resolve this issue would be greatly appreciated!

Thank you in advance for your help.