Saas · last scan Nov 2026

Metabase Problems & Issues
Open-source BI and dashboard tool, self-hosted for free or on Metabase Cloud
VERDICT TRY
70/100
Try
- signals
- 14
- sources
- 42
- known errors
- 14
// answer first
Should you use Metabase?
TryMetabase 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.
Top problems
- Why is Metabase so slow with large datasets?
- Why is Metabase Pro so expensive?
- Metabase charts are too limited to customize
Good for
- Startups wanting free internal dashboards
- Non-technical managers exploring data
- Small teams on Metabase Cloud Starter
Avoid if you are
- Analysts needing pixel-perfect visualizations
- Teams with very large datasets and no warehouse tuning
Common alternatives:
Apache Superset,
Microsoft Power BI,
Looker Studio
score breakdown
- Pricing
- 62Pricing score 62 of 100
- Usability
- 82Usability score 82 of 100
- Performance
- 55Performance score 55 of 100
- Support
- 50Support score 50 of 100
- Reliability
- 62Reliability score 62 of 100
- Onboarding
- 82Onboarding score 82 of 100
- Security
- 70Security score 70 of 100
- Integrations
- 72Integrations score 72 of 100
// score breakdown, 0-100
- Pricing
- 62Pricing score 62 of 100
- Usability
- 82Usability score 82 of 100
- Performance
- 55Performance score 55 of 100
- Support
- 50Support score 50 of 100
- Reliability
- 62Reliability score 62 of 100
- Onboarding
- 82Onboarding score 82 of 100
- Security
- 70Security score 70 of 100
- Integrations
- 72Integrations score 72 of 100
how these scores were set
Easy, free-to-self-host BI that non-technical teams actually use; held back by slow dashboards on big data, limited visual customization, self-hosting chores and a steep jump from Starter to Pro for SSO and row-level permissions.
Overview
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.
- company
- Metabase, Inc.
- website
- www.metabase.com
Metabase Not Working? Common Errors & Fixes
14 entries// step-by-step fixes for the errors users hit most
- E-01Metabase Dashboard Slow or Not LoadingMetabase 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.
- E-02Metabase 'Your Question Took Too Long' ErrorThis 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.
- E-03Metabase Not Syncing New Tables or ColumnsMetabase 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.
- E-04Metabase Filter Dropdown Not Showing ValuesDropdowns 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.
- E-05Metabase Linked Filters Not WorkingLinked 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.
- E-06Metabase Not Sending Emails or AlertsMost 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.
- E-07Metabase Can't Connect to DatabaseCheck 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.
- E-08Metabase Tables Not ShowingTables 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.
- E-09Metabase 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.
- E-10Metabase Docker Data Lost After RestartIf 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.
- E-11Metabase OutOfMemoryError: Java Heap SpaceMetabase 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.
- E-12Metabase 'Database Has Migration Lock' After UpgradeA 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.
- E-13Metabase Can't Log In or Forgot Admin PasswordUsers 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.
- E-14How to Cancel Metabase Cloud SubscriptionCancel 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.
Try it: browse a sample shop and watch visitors, funnels and live data arrive
A hands-on sandbox of how Metabase-style tools work, including where users run into trouble. Simplified illustration, not the real Metabase app. Nothing is saved.
SANDBOX · metabase LIVE, NOTHING SAVED
Our team built this sandbox from scratch. Want a real Metabase-style tool built around how you work?
Get a quote// The alternative nobody mentions
Need something Metabase can't do? We'll build it.
We're a small team of developers who build custom software fast. Your own Metabase alternative with only the features you use, or anything else: web and mobile apps, games, desktop software, AI tools, internal tools: whatever you have in mind. 50+ custom products built for clients so far, and we run our own products too: booking platforms, games, learning apps. See our work
- Web apps & SaaS
- Mobile apps (iOS & Android)
- Games
- Desktop software
- AI tools & automations
- Internal tools & dashboards
- Client portals & booking
- Your own version of any tool
- ✓ Free 15-min call to scope it
- ✓ Price agreed up front
- ✓ Your data, your code
Signals & Issues
14 signals · sorted by impact// patterns extracted from real user feedback, not raw reviews
Why is Metabase so slow with large datasets?✓ verified
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.
reported 8xnegativevia G2 (4)scaling breaks
impact7/10
Metabase charts are too limited to customize✓ verified
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.
reported 7xnegativevia Capterra (4)expectation mismatch
impact6/10
Why is Metabase Pro so expensive?✓ verified
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.
reported 7xnegativevia Other (3)hidden costs
impact7/10Metabase Starter price went up from $85 to $100✓ verified
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.
reported 4xnegativevia Other (2)price increase
impact5/10Metabase usage fees for AI, transforms and storage✓ verified
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.
reported 4xnegativevia Other (2)hidden costs
impact4/10
Metabase open source has no row-level security or SAML✓ verified
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.
reported 6xnegativevia Other (3)user type mismatch
impact7/10
Self-hosted Metabase crashes with OutOfMemoryError✓ verified
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.
reported 5xnegativevia Other (3)workflow failure
impact7/10Metabase upgrade failed: migration lock or H2 corruption✓ verified
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.
reported 5xnegativevia Other (4)migration pain
impact7/10Metabase not syncing new tables or columns✓ verified
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.
reported 7xnegativevia Other (3)workflow failure
impact6/10Metabase 'Your question took too long' timeouts✓ verified
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.
reported 6xnegativevia Other (4)workflow failure
impact6/10
Metabase dashboard filters and linked filters not working✓ verified
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.
reported 7xnegativevia Other (4)workflow failure
impact6/10Advanced Metabase dashboards still need SQL✓ verified
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.
reported 5xnegativevia Capterra (2)expectation mismatch
impact5/10Metabase exports and PDF reports are limited✓ verified
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.
reported 4xnegativevia Product Hunt (2)expectation mismatch
impact4/10
Metabase support is slow on Starter and Pro✓ verified
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.
reported 4xnegativevia Other (2)support breakdown
impact5/10
What Users Love
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 Plans
Users: Unlimited users (self-hosted)
Storage: Your own infrastructure
- ✓Unlimited charts, dashboards and queries
- ✓Query builder and SQL editor
- ✓Bring your own AI model key
- ✓Basic transforms (unlimited runs)
- ✓Guest embeds with 'Powered by Metabase' badge
Limitations: No row- or column-level permissions, no SAML/SCIM/OIDC, no white-labeling, no per-question caching controls, no advanced transforms, community forum support only
Users: 5 users included, $6 per extra user/month
Storage: 1M stored rows free, then from $2/month per 1M rows
- ✓Managed Metabase Cloud hosting
- ✓SOC 2 Type II, multi-region
- ✓Unlimited charts, dashboards and queries
- ✓Basic LDAP and Google sign-in
- ✓Email/Slack/Teams support with 3-day SLA
- ✓14-day free trial
Limitations: No SAML or row-level permissions, no custom domain, Metabase-branded exports and alerts
Users: 5 users included, $65 per extra user/year
- ✓Everything in Starter
- ✓About 10% off monthly ($1,080/year)
Limitations: Same as Starter
Users: 10 users included, $12 per extra user/month
- ✓Cloud or self-hosted
- ✓Row- and column-level permissions
- ✓SAML, OIDC, JWT, SCIM
- ✓Custom domain and custom SMTP
- ✓White-label embedding and SDK
- ✓Usage analytics, serialization, verified models
- ✓Per-question and dashboard caching
Limitations: Support still 3-day SLA; no dedicated success engineer
Users: 10 users included, $130 per extra user/year
- ✓Everything in Pro
- ✓About 10% off monthly ($6,210/year)
- ✓Invoice billing
Limitations: Same as Pro
Users: Custom
- ✓Everything in Pro
- ✓Dedicated success engineer
- ✓1-day support SLA
- ✓Single-tenant or air-gapped options
- ✓Procurement and invoice billing
Limitations: Sales-only; cannot be cancelled from the Metabase Store
Features
Querying
- No-code query builder
- SQL editor
Visualization
- Dashboards with filters
Deployment
- Self-hosting
Free under AGPL; Pro and Enterprise can also self-host
Security
- Row-level permissions
Pro and Enterprise only
- SAML / SCIM SSO
Pro and Enterprise only
Embedding
- White-label embedding
Pro and Enterprise only
AI
- Metabot AI
Bring your own key free; managed service metered on Cloud
Sharing
- Alerts and dashboard subscriptions
Needs SMTP when self-hosted
Mobile
- Native mobile app
Who Should Use This?
Good Fit
Startups wanting free internal dashboards
Self-hosted open source is free with unlimited users and covers most internal reporting.
Non-technical managers exploring data
The query builder lets people answer simple questions without SQL.
Small teams on Metabase Cloud Starter
$100/month for 5 users with no server to maintain.
Neutral
SaaS companies embedding customer dashboards
Works well but needs Pro at $575/month for white-labeling and tenant isolation.
Companies needing SSO and row-level security on a budget
Those features are Pro-only; budget for the tier jump.
Teams without anyone to run servers
Self-hosting means handling upgrades, JVM memory and the application database; use Cloud instead.
Avoid
Analysts needing pixel-perfect visualizations
Chart types and formatting are more limited than Tableau or Power BI.
Teams with very large datasets and no warehouse tuning
Metabase passes queries to your database, so slow sources mean slow dashboards.
Regret Patterns
Common buyer's remorse scenarios reported by users.
Teams try Metabase with the default H2 database or a Docker container without a volume, then lose questions and dashboards on restart or face a painful migration later.
A team builds on open source or Starter, then needs per-customer data isolation or SSO and has to jump to Pro at $575/month.
Dashboards grow to dozens of cards on raw tables until every load takes minutes and users stop opening them.
Analysts hit formatting and chart-type limits and start exporting to spreadsheets or a second BI tool.
Upgrades, JVM memory tuning, SMTP setup and migration locks take more engineering time than expected.
The only cancel button deletes the instance, so teams that wanted to keep their work must request a backup first.
When It Breaks Down
Scenarios where this product tends to fail users.
All cards query the database at once, queue up and time out; splitting dashboards and caching are the documented fix.
Nginx or a load balancer cuts the request and users see 'Your question took too long'.
Metabase samples only the first 1,000 values, so dropdowns are incomplete or switch to search boxes.
Every restart shows the setup screen again because the H2 application database lived inside the container.
Syncs and heavy queries trigger OutOfMemoryError and crashes.
Guest embeds show a 'Powered by Metabase' badge and lack tenant isolation; Pro is required.
Dates shift by hours or a full day in charts and filters until report time zone and JVM time zone line up.
Alternatives Users Switch To
Apache Superset
9x mentionedFully open source with no paid feature gates and more chart types; more SQL-first and higher-maintenance to run.
Microsoft Power BI
8x mentionedCheap per user and deep Microsoft 365 integration with richer visuals; Windows-centric and harder for casual users.
Looker Studio
7x mentionedFree and quick for Google data sources; weaker on SQL databases and governance.
Tableau
7x mentionedBest-in-class visual flexibility for analysts; far more expensive and a steeper learning curve.
Redash
5x mentionedLightweight open-source SQL dashboards; less friendly for non-SQL users and slower development.
PostHog
4x mentionedProduct analytics with SQL insights built in, if your dashboards are mostly about product usage; not a general BI tool.
Frequently Asked Questions
See how Metabase compares in our Best Analytics Software rankings, or calculate costs with our Budget Calculator.
Done fighting Metabase? Our small team builds your own Metabase alternative, or any software you need: web, mobile, games, desktop. Price agreed together.
Talk to usWork at Metabase or spotted something outdated? Suggest a correction — we verify every change against public sources. See our methodology.