Power BI Desktop vs Power BI Service

Power BI is really two products that share a name, which is why so many teams get confused. Power BI Desktop is a free Windows app where you build reports. Power BI Service is the cloud platform where you publish, refresh, and share them. Knowing which one does what — and where the licensing line falls — saves a lot of "why can't my coworker open this?" headaches.

The one-line distinction

Desktop is where you build. The Service is where you share.

You author a report on your own machine in Power BI Desktop, then publish it to the Power BI Service so colleagues can view it in a browser, on their phone, or inside Microsoft Teams. Almost every real-world workflow uses both.

What Power BI Desktop does

Power BI Desktop is the heavy-lifting authoring tool, and it costs nothing. You download it from Microsoft or the Microsoft Store, and everything below happens locally on your PC:

• Connect and shape data with Power Query — the engine that imports CSVs, Excel files, databases, and APIs, then cleans and transforms them (split columns, remove nulls, merge tables, fix data types).
• Build the semantic model — define relationships between tables, design a star schema, and write calculations. (Microsoft renamed "dataset" to semantic model in 2023; older menus and tutorials may still say "dataset.")
• Write DAX for measures and calculated columns — the formula language behind every total, ratio, and time-intelligence calculation.
• Design report pages — charts, tables, slicers, cards, bookmarks, and custom themes.

A couple of measures you'd write in Desktop look like this:

Total Sales = SUM ( Sales[Amount] )

Sales YoY % =
VAR CurrentYear = [Total Sales]
VAR PriorYear =
    CALCULATE ( [Total Sales], SAMEPERIODLASTYEAR ( 'Date'[Date] ) )
RETURN
    DIVIDE ( CurrentYear - PriorYear, PriorYear )

You never need a paid license to do any of this. You can model large tables, write hundreds of measures, and admire your work on your own screen for free. The license question only appears the moment you want someone else to see it.

One catch: Power BI Desktop is Windows-only. There is no native Mac or Linux version. Mac users typically run it in a Windows virtual machine (Parallels, a cloud VM) or rely on a colleague to author the file.

What the Power BI Service does

The Service is the cloud half — the website at app.powerbi.com. It exists to do everything Desktop can't:

• Share reports with named users, whole workspaces, or your organization via apps.
• Schedule refresh so imported data stays current automatically (say, every morning at 6 a.m.) instead of reopening Desktop and clicking refresh yourself.
• Build dashboards — single-screen canvases that pin tiles from one or more reports. This is a Service-only concept; Desktop builds reports, not dashboards.
• Package apps and workspaces — bundle related reports into a polished, read-only app you distribute to viewers.
• Govern content — row-level security enforcement, sensitivity labels, usage metrics, and audit logs.
• Access anywhere — any browser and the official mobile apps; no Windows required to view.

You can do light editing in the Service browser, but it is not a substitute for Desktop. Serious modeling — relationships, complex Power Query steps, large DAX libraries — still belongs in Desktop.

The typical workflow: Desktop → publish → Service

Almost every team follows the same loop:

1. Author in Power BI Desktop
   - Get data (Power Query) -> model (relationships, DAX) -> design pages
2. Save as a .pbix (or .pbip) file
3. Publish to a workspace in the Power BI Service
4. In the Service:
   - Configure scheduled refresh + data source credentials
   - Build a dashboard (optional) and an app
   - Share with viewers
5. Need a change? Edit in Desktop -> publish again (overwrites the cloud copy)

The file is the round-trip artifact. You keep editing it in Desktop and re-publishing; the Service version updates each time. On formats: the classic .pbix is a single binary file, while the newer .pbip (Power BI Project) stores the report and model as plain-text folders — far friendlier for Git and code review. Desktop opens and publishes both.

Licensing: where the free ride ends

This trips up nearly everyone. The rule of thumb:

• Authoring in Desktop is always free.
• Sharing through the Service requires a paid license — yours and, in most cases, your viewers'.

The common tiers, with public approximate pricing as of 2026:

• Power BI Pro (about $14/user/month): publish, share, and consume shared content. The publisher and each viewer generally both need Pro. This is the standard for most small and mid-size teams.
• Power BI Premium Per User (PPU) (about $24/user/month): Pro features plus larger models, more frequent refresh, and advanced capabilities — but everyone collaborating on that content also needs PPU.
• Microsoft Fabric capacity (formerly Premium per capacity): you pay for a dedicated capacity (an "F SKU") rather than per person. With a large enough capacity, viewers can consume content with only a free license — which is why bigger organizations move to capacity-based licensing.

A frequent surprise: you can publish a report to the Service, but if you are on a free account outside a Fabric capacity, your colleagues can't open it without their own Pro license. "I published it — why can't they see it?" is almost always a licensing gap, not a bug. (Exact pricing varies by region, agreement, and billing term; always confirm current rates with Microsoft.)

Where Microsoft Fabric fits in

Power BI now lives inside Microsoft Fabric, Microsoft's broader analytics platform (data warehouses, pipelines, notebooks, real-time analytics). For day-to-day report building, nothing changes: you still author in Power BI Desktop and publish to workspaces in the Service. Fabric mostly matters when you need enterprise-scale data engineering or capacity-based licensing. If you're producing reports from CSVs and spreadsheets, you can safely treat Power BI as Desktop + Service and leave Fabric for later.

Quick decision guide

• Just want to look at a chart on your own PC? Power BI Desktop, free, done.
• Need teammates to see a live report in a browser? Publish to the Service; everyone needs Pro (or you need Fabric capacity).
• Want data to refresh automatically overnight? That's the Service — Desktop can't schedule refresh.
• On a Mac? View in the Service browser; author via a Windows VM or have someone build the file for you.
• Building a polished package for many viewers? Use a workspace and publish an app in the Service.

Don't think of Desktop and Service as competitors. They are two halves of one pipeline — build for free in Desktop, then publish to the Service when it's time to share, refresh, and govern.

Skip the build, get a finished report

If the modeling-and-DAX half of that pipeline isn't where you want to spend your week, that's where Instant PowerBI comes in. Send us your raw CSV or Excel files and we'll send back a finished, fully modeled, branded Power BI report — a clean star schema, the measures you need, and a custom theme. It opens directly in free Power BI Desktop, so you can publish it to the Service yourself whenever you're ready to share. Want to match your colors first? Try our free Power BI theme generator, or get started here.