# Metabase Problems & Issues 2026 - Slow Dashboards, Sync & Pricing

Source: https://www.tryorbye.com/products/metabase
Last analyzed: 2026-11-16
Try or Bye score: 70/100

## Verdict: Try

Metabase is worth trying for most users (score 70/100). Most reported issues: Why is Metabase so slow with large datasets?; Why is Metabase Pro so expensive?; Metabase charts are too limited to customize. Not a good fit for: Analysts needing pixel-perfect visualizations; Teams with very large datasets and no warehouse tuning. Users most often switch to Apache Superset, Microsoft Power BI, Looker Studio.

## What it is

Metabase is an open-source business intelligence tool that lets teams query databases, build charts and share dashboards without writing SQL, with a SQL editor for analysts. It can be self-hosted for free under the AGPL license or run on Metabase Cloud (Starter, Pro, Enterprise), and the paid tiers add SSO, row-level permissions, caching controls and white-label embedding.

## Common errors & fixes

### How to Cancel Metabase Cloud Subscription

Cancel Starter or Pro in the Metabase Store: Instances > Settings > Cancel subscription and delete instance. Cancelling deletes the instance, so ask support for an application database backup first if you want to keep your work. Enterprise must contact support.

1. **Back up before cancelling** — Contact Metabase support and ask for a backup of your application database Export any results you need as CSV/XLSX Restore the backup on a self-hosted Metabase if you are moving
2. **Cancel Starter or Pro in the Metabase Store** — Log in at store.metabase.com Go to Instances Click Settings on the instance Click Cancel subscription and delete instance Share feedback or click Skip Click Yes, cancel
3. **Downgrade instead of cancelling** — In the Store go to Instances and select the instance Click Manage plan, choose Starter and click Change plan
4. **Cancel Enterprise** — Enterprise plans can't be cancelled in the Store Contact Metabase support or your account manager before the renewal date

Full guide: https://www.tryorbye.com/products/metabase/issues/cancel

### Metabase Can't Connect to Database

Check whether the problem is on the Metabase side (connection settings, version support) or the database side (server down, network or IP allowlist, credentials, privileges). On Metabase Cloud, add Metabase's IP addresses to your database allowlist.

1. **Test the network path** — From the Metabase host run nc -v your-db-host 5432 (use your port) If it fails, open the firewall or security group for Metabase's IP
2. **Allowlist Metabase Cloud IPs** — Find Metabase Cloud's IP addresses in the Cloud docs Add them to your database's allowlist or security group
3. **Verify credentials and privileges** — Log in with the same user via psql or your database client Grant SELECT on the schemas Metabase needs
4. **Fix SSL certificate errors** — Go to Admin > Databases > your database > Show advanced options In Additional JDBC connection string options add trustServerCertificate=true (SQL Server) Save and retry
5. **Confirm the connection** — Open the SQL editor and run SELECT 1 Check Admin > Tools > Logs for the real error if it fails

Full guide: https://www.tryorbye.com/products/metabase/issues/cant-connect-database

### Metabase Can't Log In or Forgot Admin Password

Users can be reset by an admin from the People page. A self-hosted admin who is locked out can generate a reset token with java -jar metabase.jar reset-password; Metabase Cloud admins must contact support.

1. **Reset a user's password (admin)** — Go to Admin > People Click the three dots next to the person and choose Reset Password If email isn't set up, share the temporary password Metabase shows
2. **Reset the admin password (self-hosted)** — Stop Metabase Run java -jar metabase.jar reset-password admin@example.com and copy the token Start Metabase normally Open https://your-metabase/auth/reset_password/TOKEN and set a new password
3. **Metabase Cloud admin** — Contact Metabase support from metabase.com/help-premium Note that the store.metabase.com password is separate from your instance password
4. **Check Site URL and account status** — Admin > Settings > General: confirm the Site URL Admin > People: make sure the account isn't deactivated

Full guide: https://www.tryorbye.com/products/metabase/issues/cant-log-in

### Metabase Dashboard Slow or Not Loading

Metabase dashboards slow down when many cards query the database at once, queries scan raw tables, or the database itself is slow. Split the dashboard into smaller ones (10 cards or fewer), filter queries and turn on caching.

1. **Rule out the browser** — Open the dashboard in a private or incognito window If it loads faster, clear the browser cache and disable extensions
2. **Split the dashboard** — Group related cards (for example weekly vs monthly metrics) Move each group to its own dashboard with 10 or fewer cards Link the dashboards with custom click destinations
3. **Turn on caching** — Go to Admin > Performance > Database caching Set a Default policy (Adaptive, Duration or Schedule) On Pro/Enterprise, set caching on the busiest dashboard and enable Refresh cache automatically
4. **Slim down each question** — Remove fields you don't need Add filters such as a narrower date range Remove joins to unused tables Ask your database admin for a pre-aggregated view instead of aggregating raw tables
5. **Pre-filter guest embeds** — In the embed settings, add a locked parameter Pass the value from your app so each embed queries a smaller slice
6. **Check the database** — If every dashboard is slow, run the same query directly on the database If it is slow there too, add indexes or move to a faster warehouse

Full guide: https://www.tryorbye.com/products/metabase/issues/dashboard-slow

### Metabase Docker Data Lost After Restart

If the setup screen appears every time the container restarts, Metabase's application database lived inside the container. Mount a persistent volume, and for production move from H2 to PostgreSQL.

1. **Mount a persistent volume** — Stop the container Run it again with a volume mounted for the application database (the docs use the /metabase.db directory for H2) Confirm data survives a restart
2. **Move to PostgreSQL** — Create a PostgreSQL database for Metabase Set MB_DB_TYPE=postgres plus MB_DB_DBNAME, MB_DB_PORT, MB_DB_USER, MB_DB_PASS, MB_DB_HOST If you have an H2 file, run java -jar metabase.jar load-from-h2 /path/to/metabase.db (without .mv.db)
3. **Check the logs for a fresh H2 database** — Run docker logs CONTAINER_ID If it reports creating a new H2 database, your MB_DB_* variables are wrong Check them with docker inspect

Full guide: https://www.tryorbye.com/products/metabase/issues/docker-data-lost

### Metabase Filter Dropdown Not Showing Values

Dropdowns only appear for fields Metabase treats as categories with scanned values, and it samples only the first 1,000 unique values. Set the field to a dropdown in Table Metadata, then discard cached values and re-scan.

1. **Discard and re-scan field values** — Go to Admin > Table Metadata and pick the database and table Click the gear icon on the column Click Discard cached field values, then Re-scan this field
2. **Set the filter type** — In Admin > Table Metadata, open the column Set Filtering on this field to A list of all values For very high-cardinality columns use Search box instead
3. **Check the scan logs** — Go to Admin > Tools > Logs Look for scan errors on that field
4. **Check the dashboard wiring** — Edit the dashboard and click the filter Make sure every card maps to the same field Remove or remap a card that uses a different table

Full guide: https://www.tryorbye.com/products/metabase/issues/filter-dropdown-empty

### Metabase Linked Filters Not Working

Linked filters need an explicit foreign key relationship between the tables and must be linked in the right direction. Define the foreign key in Table Metadata, check the link direction and avoid using models or saved questions as the filter source.

1. **Define the foreign key** — Go to Admin > Table Metadata Open the column that references the other table Set its type to Foreign Key and choose the target table and column
2. **Check the link direction** — Edit the dashboard and click the child filter Open Linked filters and enable linking to the parent filter Save the dashboard
3. **Use tables, not models, as the source** — Point both filters at fields from raw tables Test again before reintroducing models
4. **Test outside the embed** — Open the same dashboard logged in If it works there, the problem is the embed or public link configuration or version

Full guide: https://www.tryorbye.com/products/metabase/issues/linked-filters-not-working

### Metabase 'Database Has Migration Lock' After Upgrade

A previous upgrade or crash left a lock in the application database, so Metabase refuses to start. Make sure no other instance is running, back up the database, then release the lock with java -jar metabase.jar migrate release-locks.

1. **Stop every other instance** — Scale to a single Metabase instance Confirm no other container is connected to the application database
2. **Back up, then release the lock** — Back up the application database Run java -jar metabase.jar migrate release-locks with the same MB_DB_* settings Start Metabase normally
3. **Give migrations time** — Raise your orchestrator's health-check or startup timeout Watch docker logs until migrations finish
4. **Read the first error, not the last** — Search the logs for the first ERROR line If a migration partly applied, restore the backup and upgrade again, or post the error on the Metabase forum

Full guide: https://www.tryorbye.com/products/metabase/issues/migration-lock

### Metabase Not Sending Emails or Alerts

Most cases are wrong SMTP settings or a mail service that blocks the sender or recipient domain. Send a test email from Admin > Email, read the error in Admin > Tools > Logs, and check spam and DKIM if mail is sent but not received.

1. **Send a test email** — Go to Admin > Email Check host, port, security, username and password Click Save changes, then Send test email
2. **Read the error** — Go to Admin > Tools > Logs and look for SMTP errors Test the same credentials in another email client
3. **Check the delivery service** — Allow sending to the recipients' domain Verify the from address you use in Metabase Turn off test or sandbox mode Check the service's outbound queue or logs
4. **Fix deliverability** — Check spam folders and forwarding rules Set up DKIM for your sending domain

Full guide: https://www.tryorbye.com/products/metabase/issues/not-sending-email

### Metabase Not Syncing New Tables or Columns

Metabase only sees schema changes after a sync. Trigger Sync database schema in Admin > Databases, check Admin > Tools > Logs for errors, and update drivers if you self-host.

1. **Run a manual sync** — Go to Admin > Databases and pick your database Click Sync database schema Wait a few minutes and refresh
2. **Read the sync logs** — Go to Admin > Tools > Logs Look for sync errors for that database Run SELECT * FROM the_table in the SQL editor to surface permission errors
3. **Disable JSON unfolding for slow syncs** — Admin > Databases > your database > Show advanced options Turn off JSON unfolding and click Save changes Click Sync database schema
4. **Sync less** — Restrict the Metabase database user to the schemas you need Reduce sync and scan frequency in the database's advanced options
5. **Update Metabase and drivers (self-hosted)** — Upgrade to the latest Metabase release Update any community database drivers

Full guide: https://www.tryorbye.com/products/metabase/issues/not-syncing

### Metabase OutOfMemoryError: Java Heap Space

Metabase runs on the JVM and crashes with 'java.lang.OutOfMemoryError: Java heap space' when the heap is too small for syncs or heavy queries. Raise the heap with -Xmx (JAVA_OPTS in Docker) and capture a heap dump if it keeps happening.

1. **Give the JVM more heap** — JAR: start with java -Xmx2g -jar metabase.jar (or more) Docker: set JAVA_OPTS=-Xmx2g Keep the heap below the container's memory limit
2. **Capture a heap dump** — Add -XX:+HeapDumpOnOutOfMemoryError -XX:HeapDumpPath=/some/dir Open the dump in Eclipse Memory Analyzer or VisualVM to find the query or job using memory
3. **Run a supported Java version** — Check the Java version Metabase's docs require for your release Upgrade Java and restart
4. **Reduce memory pressure** — Limit row counts on exports and big questions Reduce sync and scan frequency for large databases

Full guide: https://www.tryorbye.com/products/metabase/issues/out-of-memory

### Metabase 'Your Question Took Too Long' Error

This error usually means something between Metabase and the database cut the request, very often a load balancer or Nginx proxy with a 60-second timeout. Raise the proxy timeout, then speed up the query itself.

1. **Check the proxy or load balancer timeout** — If the error appears at exactly 60 seconds, look at your load balancer idle timeout For Nginx, raise proxy_read_timeout in the Metabase server block and reload Nginx Check the browser Network tab to see which layer returned the error
2. **Check the database timeout** — Ask your DBA whether the database or the Metabase user has a statement timeout Raise it for the Metabase user if appropriate
3. **Raise Metabase's query timeout (self-hosted)** — Set the MB_DB_QUERY_TIMEOUT_MINUTES environment variable Restart Metabase
4. **Compare with the database directly** — Run the same SQL in your database client If it is just as slow, optimize the query, add indexes or pre-aggregate If it is much faster outside Metabase, review your Metabase deployment and resources
5. **Fix column types** — Store dates and numbers in native types instead of text Avoid casts in filters on large tables

Full guide: https://www.tryorbye.com/products/metabase/issues/question-took-too-long

### Metabase Tables Not Showing

Tables disappear from Metabase when they are hidden in Table Metadata, blocked by group permissions, renamed or dropped in the database, or the browser shows a stale list. Run SELECT 1 and SELECT * FROM the table in the SQL editor to find which.

1. **Rule out the browser** — Open Metabase in an incognito window Clear cache or disable extensions if that fixes it
2. **Test the table in SQL** — Open the SQL editor and run SELECT 1 Run SELECT * FROM your_table and read any 'not found' or 'permission denied' error
3. **Check visibility** — Go to Admin > Table Metadata and select the database Make sure the table's visibility isn't Hidden
4. **Check group permissions** — Go to Admin > Permissions > Data Give the user's group access to the schema or table
5. **Re-sync** — Admin > Databases > your database > Sync database schema

Full guide: https://www.tryorbye.com/products/metabase/issues/tables-not-showing

### Metabase Dates and Times Wrong (Timezone Off)

Dates shift by hours or a whole day when Metabase's report time zone, the JVM time zone and the database's time zone don't line up. Set the report time zone in Admin > Settings > Localization, or match the JVM time zone to the database.

1. **Set the report time zone** — Go to Admin > Settings > Localization Set Report Timezone to your business time zone Re-run the question
2. **Match the JVM time zone (self-hosted)** — Set the JAVA_TIMEZONE environment variable (or -Duser.timezone) to the database's time zone Restart Metabase
3. **Convert explicitly in SQL** — Use your database's conversion, for example column::TIMESTAMP AT TIME ZONE 'EST' in PostgreSQL
4. **Diagnose the offset** — Drill into a day you know is wrong Shift the filter by hours and compare the offset to the database and Metabase time zones

Full guide: https://www.tryorbye.com/products/metabase/issues/wrong-timezone

## Common problems

- **Why is Metabase so slow with large datasets?** (performance): Slow performance is the most-cited con on G2 and shows up in Capterra and SaaSworthy reviews too: dashboards and queries lag once tables get large or many cards run at once. Metabase's own docs say a 50-card dashboard is almost always slower than five 10-card dashboards.
- **Why is Metabase Pro so expensive?** (pricing): Starter is $100/month for 5 users, but SSO (SAML), row- and column-level permissions, custom domains and full embedding need Pro at $575/month for 10 users plus $12 per extra user. Enterprise starts at $20,000 per year, so the jump between tiers is steep for small teams.
- **Metabase charts are too limited to customize** (customization): Reviewers on G2, Capterra and Software Advice say visualization options and formatting control sit a step below Tableau or Power BI. Teams that want pixel-level dashboard design or unusual chart types hit the ceiling quickly.
- **Metabase open source has no row-level security or SAML** (security): The free edition lacks row- and column-level permissions, SAML, SCIM and white-labeling, and exports and scheduled emails carry Metabase branding. Teams that need per-customer data isolation discover they must move to Pro.
- **Metabase not syncing new tables or columns** (reliability): A frequent forum and docs topic: new tables, columns or changed types don't show up until a sync runs, and JSON unfolding or large schemas make syncs slow. Filter dropdowns only sample the first 1,000 values per field.
- **Metabase dashboard filters and linked filters not working** (usability): Dropdowns that don't populate, linked filters that show every value, and filters broken in embeds or public links are among the most common forum threads. Causes include fields not set as Category, missing foreign keys and models used as filter sources.
- **Metabase 'Your question took too long' timeouts** (reliability): Long queries end with 'Your question took too long', often at exactly 60 seconds because a load balancer or Nginx proxy cuts the request. Users report raising Metabase-side timeouts doesn't help until the proxy is fixed.
- **Self-hosted Metabase crashes with OutOfMemoryError** (reliability): Self-hosters report 'java.lang.OutOfMemoryError: Java heap space' crashes, sometimes recurring every 12-24 hours. Metabase runs on the JVM and needs 2 GB+ of RAM; the docs recommend raising the heap with -Xmx and capturing heap dumps.
- **Metabase upgrade failed: migration lock or H2 corruption** (reliability): Upgrades can stop at 'Database has migration lock' or fail halfway, and the default H2 application database can corrupt or lose data. Metabase's docs say H2 is not for production and recommend migrating to PostgreSQL.
- **Advanced Metabase dashboards still need SQL** (usability): The query builder covers simple questions, but Capterra reviewers say complex metrics, cross-database work and advanced dashboards push users back to SQL, and large libraries of questions become hard to organize.
- **Metabase Starter price went up from $85 to $100** (pricing): Pricing trackers record Starter rising from $85 to $100 per month and the Pro per-user add-on from $10 to $12 in Q3 2025. Existing cloud customers on monthly billing pay the new rate.
- **Metabase support is slow on Starter and Pro** (support): Open source users get community forum help only, and Starter and Pro come with a 3-day support SLA. A 1-day SLA and a dedicated success engineer are Enterprise-only, from $20,000 per year.
- **Metabase usage fees for AI, transforms and storage** (pricing): On Cloud, the managed AI service is free for the first 1M tokens then $3.75 per 1M, transforms are free for 1,000 runs then 1-2 cents per run, and built-in storage is billed per million rows. A development instance costs another $100/month on Pro.
- **Metabase exports and PDF reports are limited** (usability): Product Hunt and review-site users mention awkward exports, limits on emailed and PDF reports, and Metabase branding on exports and subscriptions on the free and Starter plans.

## What users like

- **Easy enough for non-technical teams**: Ease of use is the most praised trait on G2 and Capterra: managers and small-business teams build questions and dashboards with the query builder without SQL.
- **Free open-source edition with unlimited users**: Self-hosted Metabase is free under the AGPL with unlimited users, charts and dashboards, which makes it a common first BI tool for startups.
- **Fast setup with Docker or Cloud**: A single Docker container or a Cloud trial gets a team to its first dashboard in minutes; reviewers highlight quick setup compared with Tableau or Power BI.
- **Connects to most SQL databases and warehouses**: PostgreSQL, MySQL, Snowflake, BigQuery, Redshift, SQL Server, MongoDB and more connect directly, with a SQL editor for analysts.
- **Embedded analytics and SDK on Pro**: Pro adds white-label full-app embedding, a modular SDK and tenant isolation, which teams use to ship customer-facing dashboards without building their own.
- **Unlimited dashboards and queries on every plan**: No plan charges for more dashboards, questions or data source connections; billing is based on users who sign in.

## Pricing

- **Open Source**: $0.00 (free) — hidden costs: You pay for and maintain the server (2 GB+ RAM recommended) and a PostgreSQL application database; you need your own SMTP server for email; Metabase branding on exports and scheduled deliveries
- **Starter**: $100.00 (monthly) — hidden costs: AI service $3.75 per 1M tokens after the first 1M; transforms 1-2 cents per run after 1,000 free runs; storage beyond 1M rows
- **Starter (annual)**: $90.00 (yearly) — hidden costs: Usage-based add-ons get no annual discount; you can't switch back to monthly until the annual term ends
- **Pro**: $575.00 (monthly) — hidden costs: Development instance $100/month extra; embed viewers who sign in count as billed users; AI and transform usage fees on Cloud
- **Pro (annual)**: $517.50 (yearly) — hidden costs: Annual commitment; usage add-ons not discounted
- **Enterprise**: yearly — hidden costs: Minimum $20,000/year; cloud transforms $9,000-$18,000/year; single-tenant and air-gapped deployments cost extra

## Who should and shouldn't use it

- **Startups wanting free internal dashboards** — Good fit: Self-hosted open source is free with unlimited users and covers most internal reporting.
- **Non-technical managers exploring data** — Good fit: The query builder lets people answer simple questions without SQL.
- **Small teams on Metabase Cloud Starter** — Good fit: $100/month for 5 users with no server to maintain.
- **SaaS companies embedding customer dashboards** — Depends: Works well but needs Pro at $575/month for white-labeling and tenant isolation.
- **Analysts needing pixel-perfect visualizations** — Avoid: Chart types and formatting are more limited than Tableau or Power BI.
- **Teams with very large datasets and no warehouse tuning** — Avoid: Metabase passes queries to your database, so slow sources mean slow dashboards.
- **Companies needing SSO and row-level security on a budget** — Depends: Those features are Pro-only; budget for the tier jump.
- **Teams without anyone to run servers** — Depends: Self-hosting means handling upgrades, JVM memory and the application database; use Cloud instead.

## Alternatives

- **Apache Superset** (https://www.tryorbye.com/products/apache-superset): Fully open source with no paid feature gates and more chart types; more SQL-first and higher-maintenance to run.
- **Microsoft Power BI** (https://www.tryorbye.com/products/power-bi): Cheap per user and deep Microsoft 365 integration with richer visuals; Windows-centric and harder for casual users.
- **Looker Studio** (https://www.tryorbye.com/products/looker-studio): Free and quick for Google data sources; weaker on SQL databases and governance.
- **Tableau** (https://www.tryorbye.com/products/tableau): Best-in-class visual flexibility for analysts; far more expensive and a steeper learning curve.
- **Redash**: Lightweight open-source SQL dashboards; less friendly for non-SQL users and slower development.
- **PostHog** (https://www.tryorbye.com/products/posthog): Product analytics with SQL insights built in, if your dashboards are mostly about product usage; not a general BI tool.

## FAQ

### Is Metabase worth it?

For startups and small teams that want simple internal dashboards, yes: the open-source edition is free and Starter Cloud is $100/month for 5 users. It is less worth it if you need advanced visual customization or if you need SSO and row-level security, which push you to Pro at $575/month.

### Is Metabase free?

Yes, Metabase Open Source is free to self-host with unlimited users under the AGPL license. You pay for your own server and maintenance, and you lose row-level permissions, SAML and white-labeling.

### How much does Metabase cost?

Open Source is free. Starter is $100/month ($90/month billed annually) for 5 users plus $6 per extra user. Pro is $575/month ($517.50/month annually) for 10 users plus $12 per extra user. Enterprise is custom with a $20,000/year minimum.

### Why is Metabase so slow?

Metabase runs each card's query against your database, so dashboards with many cards, unfiltered queries on big tables and slow databases make it lag. Split large dashboards, add filters, enable caching (Admin > Performance on Pro) and pre-aggregate data in the warehouse.

### Why is Metabase not showing my new table?

Metabase only sees new tables after a schema sync. Go to Admin > Databases > your database and click Sync database schema, then check Admin > Tools > Logs and confirm the table isn't set to Hidden in Admin > Table Metadata.

### What does Metabase open source not include?

No row- and column-level permissions, SAML, SCIM, OIDC, white-label embedding, custom domains, usage analytics or per-question caching controls. Exports and scheduled emails carry Metabase branding.

### Metabase vs Superset: which is better?

Metabase is easier for mixed-skill teams and quicker to set up. Superset is fully open source with more chart types and no paid feature gates, but it is more SQL-first and needs more maintenance.

### Can Metabase handle large datasets?

Only as well as your database can. Metabase does not store your data; it sends queries to the source. Large datasets need a fast warehouse, pre-aggregated tables and caching to keep dashboards responsive.

### How do I cancel Metabase Cloud?

Log in at store.metabase.com, go to Instances, open the instance Settings and click Cancel subscription and delete instance, then confirm with Yes, cancel. This deletes the instance, so ask support for an application database backup first if you want to self-host. Enterprise plans must contact support.

### Does Metabase have row-level security?

Yes, but only on Pro and Enterprise. The free open-source edition and Starter cannot restrict rows or columns per user or group.

### How much RAM does Metabase need?

Metabase runs on the JVM, so plan for at least 2 GB, and more for many users or heavy syncs. If you see java.lang.OutOfMemoryError, raise the heap with -Xmx (or JAVA_OPTS in Docker).

### Should I use H2 for Metabase in production?

No. Metabase's docs recommend against H2 in production because the file can corrupt, and you cannot run multiple instances on it. Migrate to PostgreSQL or MySQL with the load-from-h2 command.

### Does Metabase have AI?

Yes, Metabot. Bringing your own model key is free on every plan; Metabase's managed AI service on Cloud is free for the first 1M tokens, then $3.75 per 1M tokens on Starter and Pro.

---
Try or Bye aggregates problem patterns from user reviews, forums, and app stores. Methodology: https://www.tryorbye.com/methodology