Software profile

Microsoft Fabric

Microsoft's unified analytics platform on OneLake, billed by capacity units; an F2 capacity is about $263 a month pay-as-you-go, with a 60-day trial.

  • Free trial
  • Capacity units
  • Cloud
  • Unified analytics
  • Independent sources

by MicrosoftCloud Data Warehouse SoftwareUnified analytics on OneLake

  • Verified 11 Nov 2026Sources are dated on this profile
  • 1 sourceLinked, typed and dated
  • Independent third-party sourcesHow this profile was compiled
  • Not an endorsementStack18 has not tested this product
Quick answer

What is Microsoft Fabric?

Microsoft Fabric is a unified analytics platform combining data engineering, warehousing, real-time analytics and Power BI on a single OneLake data lake, billed by capacity (F-SKUs).

  • Best forMicrosoft 365 and Azure organisations standardising on Power BI
  • Team size fitMid-size teams, Large enterprises
  • PricingF2 ~$0.36/hour PAYG (2 CUs at $0.18/CU-hour), ~$263/month if always on; 1-year reserved F2 ~$156/month; 1-minute minimum.
  • Main limitationShared CU pools cause contention.
  • AlternativesDatabricks, Snowflake, Amazon Redshift · compare all
Overview

Microsoft Fabric overview: who it is for and what it does.

Fabric keeps one copy of data in OneLake for warehouse, notebooks and Power BI, with autoscale.

A vendor comparison (August 2026) lists F2 at about $0.36 an hour pay-as-you-go in US regions (2 CUs at $0.18 per CU-hour), roughly $263 a month if left on, and about $156 a month on a 1-year reservation, with a 1-minute minimum and a 60-day trial.

It notes shared capacity pools can let a Spark job starve a dashboard and several engines are young.

Main problem it solves

Unifies data and BI in the Microsoft stack.

Typical customer segment

Microsoft-centric organisations.

Target users

  • BI teams
  • Data engineers
  • IT leaders

Primary use cases

  • OneLake
  • Warehouse
  • Notebooks
  • Power BI

What makes it distinct

  • OneLake.
  • Capacity SKUs.
  • Power BI native.
Key features

Microsoft Fabric features explained.

Capacity (F2, US)

PAYG
~$0.36/hour.
Always on
~$263/month.
1-year reserved
~$156/month.

Platform

Storage
OneLake single copy.
BI
Power BI.
Scaling
Autoscale.

Watch-outs

Shared CUs
Spark can starve dashboards.
Engines
Some young.
Compute
Proprietary.
Pricing

Microsoft Fabric pricing and plans.

Figures reported by independent sources; vendor page not reviewed directly. Checked 11 Nov 2026 against MotherDuck.

Pricing model

Capacity units (F-SKUs).

Free plan

No

Free trial

Yes (60 days)

Microsoft Fabric plans and prices (USD)

  • F2 PAYG

    ~$0.36 per hour

    Pay as you go

    2 CUs.

  • F2 reserved

    ~$156 per month

    1-year reservation

    2 CUs.

  • Larger F-SKUs

    Scales with CUs

    PAYG or reserved

    More capacity.

MotherDuck (August 2026), vendor.

Prices change. Confirm current plans and terms on the vendor's site before you decide.

Visit official website (external) ↗See alternatives
Integrations and compatibility

Microsoft Fabric integrations, API and platforms.

Important integrations

  • Power BI
  • Azure
  • Microsoft 365
  • Dataverse

Supported platforms

  • Web

API

Not reviewed for this profile.

Data import and export

Not reviewed for this profile.

Integration coverage was not assessed in full. Check Microsoft Fabric's integrations directory and documentation for your tools.

Strengths, limitations and best fit

Microsoft Fabric pros and cons.

Strengths, limitations and best fit. Each point cites a source; editorial summaries are not customer reviews.

Strengths

  • One copy of data in OneLake. [1]
  • Native Power BI. [1]
  • 60-day trial. [1]

Limitations

  • Shared CU pools cause contention. [1]
  • Proprietary compute. [1]
  • Several engines are young. [1]

Best for

  • Microsoft 365 and Azure organisations standardising on Power BI
  • BI-led data teams
  • Enterprises consolidating tools

May be less suited to

  • Non-Microsoft stacks
  • Per-query serverless needs
How it compares

Microsoft Fabric compared with similar cloud data warehouse and lakehouse platforms.

Summaries come from each profile. This is a side-by-side aid, not a ranking.

ProductPricing modelEntry rateFree tierArchitectureBest for
Microsoft FabricCapacity (F-SKU)~$0.36/hour (F2)No; 60-day trialLakehouse (OneLake)Microsoft shops
Amazon RedshiftRPU-hour / node-hour$0.375/RPU-hourTrial creditsCloud warehouseAWS teams
ClickHouse CloudCompute + storage$0.2181/unit-hour (Basic)OSS free; $300 trialReal-time column storeReal-time analytics
DatabricksDBU usage~$0.70/DBU (SQL Serverless)No; 14-day trialLakehouseBI + ML
FireboltPer-second nodes~$0.92/hour (1x S)$200 creditsCloud warehouseLow-latency apps
Google BigQueryPer TiB / slots$6.25/TiB scannedYes (1 TiB/mo)Serverless warehouseGoogle Cloud

Browse all Cloud Data Warehouse Software →

Comparisons

Microsoft Fabric vs competitors: head-to-head comparisons.

Each comparison has a feature table, pricing side by side, strengths and limits, and best-fit scenarios.

Compare Microsoft Fabric with all its alternatives in one table →

Discussions

Microsoft Fabric discussions and buying questions.

No published discussions mention this product yet.

FAQ

Microsoft Fabric questions and answers

What is Microsoft Fabric used for?

Microsoft Fabric is a unified analytics platform combining data engineering, warehousing, real-time analytics and Power BI on a single OneLake data lake, billed by capacity (F-SKUs). Typical uses include oneLake, warehouse, notebooks, power BI.

How much does Microsoft Fabric cost?

An F2 capacity is about $0.36 an hour pay-as-you-go (~$263 a month always on) or ~$156 a month reserved for a year.

Is there a Fabric trial?

Yes, 60 days.

What is OneLake?

Fabric's single data lake shared by all workloads.

How does Microsoft Fabric compare with its competitors?

Stack18 publishes head-to-head comparisons of Databricks vs Microsoft Fabric, each with a feature table, pricing and best-fit scenarios.

What are the main alternatives to Microsoft Fabric?

The main alternatives to Microsoft Fabric covered on Stack18 are Databricks, Snowflake and Amazon Redshift. Databricks may suit teams combining BI, data engineering and ML on one copy of data. Snowflake may suit enterprises running large batch analytics and data sharing. Amazon Redshift may suit AWS-centric teams needing a warehouse close to S3. See the Microsoft Fabric alternatives guide for a side-by-side table.

What are the pros and cons of Microsoft Fabric?

Strengths: One copy of data in OneLake. Native Power BI. Limitations: Shared CU pools cause contention. Proprietary compute.

Who is Microsoft Fabric best for?

Microsoft Fabric may suit Microsoft 365 and Azure organisations standardising on Power BI; BI-led data teams; enterprises consolidating tools. It may be less suited to non-Microsoft stacks; per-query serverless needs.

What integrations does Microsoft Fabric support?

Documented integrations and ecosystem items include Power BI, Azure, Microsoft 365, Dataverse. API: Not reviewed for this profile.

When was the Microsoft Fabric profile last verified?

Sources for this profile were last reviewed on 11 Nov 2026. 1 source is listed under Sources, and prices and plans can change, so confirm with the vendor.

Sources and freshness

Where this information comes from.

  1. Top Snowflake Alternatives 2026 (20 August 2026) MotherDuck (vendor blog) Competitor Accessed 11 Nov 2026

Secondary-source profile. Vendor pages were not reviewed directly for this profile. Facts and prices are taken from independent third-party sources and may differ from the vendor's current pages. Confirm with the vendor before buying.

List rates come from dated third-party and vendor sources (labelled); real bills depend on workload, region and discounts. Confirm with the vendor before buying. Capabilities were not tested.

Stack18 has not tested this product or received anything from the vendor for this profile. Editorial summaries of vendor information are not endorsements. Confirm details with the vendor before buying.

Next step

Evaluating Microsoft Fabric?

Check the vendor's current pricing and terms, compare it with similar products, or read how others approach the decision. If off-the-shelf is not the answer, Stack18 builds around how your business works.

Logos provided by Logo.dev. Product names and logos are trademarks of their respective owners and appear for identification only; they do not imply endorsement.