Back to Blog

What Power BI Free Users Actually Get - And Where the Walls Are

June 9, 20268 min readMichael Ridland

The phrase "Power BI is free" gets thrown around in Australian sales meetings the way "we have Microsoft 365" gets thrown around in IT meetings. Both statements are technically true and almost always misleading. Power BI free is a real thing. It does real work. But the boundary between free and Pro is the one that catches most teams out, and getting the licencing wrong at the start can cost you a six-figure migration later.

I've sat across the table from too many CFOs who thought they were saving money by running on the free tier, only to find their analyst was emailing PDFs around because nobody could share a workspace. So this post is a straight read on what the free user actually gets in Power BI, what they can't do, and how we usually advise clients to make the call.

What the free licence is

When Microsoft says Power BI is free, they mean two related things. The first is Power BI Desktop, which is a Windows application you can download and use forever without paying anyone. The second is a Power BI service licence at the free tier, which lets you log into app.powerbi.com and do a limited set of things.

Power BI Desktop is the same software for everyone. There is no Pro version of the desktop tool. Whether you've paid Microsoft thousands or nothing, you get the same modelling engine, the same DAX library, the same visuals, and the same export options. This is the bit that catches people out. They open Desktop, build a beautiful model, save the PBIX file, and assume they're up and running. They are, right up until they want anyone else to see it.

The free service licence is where the limits show up. With a free Power BI account you can publish content to the service, but only to your personal workspace ("My Workspace"). You can view content that has been shared with you, but only if it's been published into a Premium capacity or a Fabric capacity. You can use a small set of features that don't require a Pro licence. That's about it.

What free users can actually do

Free users can:

  • Use Power BI Desktop with no restrictions
  • Sign into the Power BI service
  • Publish reports to their personal workspace
  • View dashboards and reports shared from a Premium capacity or Fabric workspace
  • Use Power BI on the web for personal exploration
  • Connect to data sources, build reports, refresh data manually
  • Export to PowerPoint, PDF, Excel from the reports they view
  • Use Q&A within their personal workspace
  • View reports embedded in Microsoft Teams if the workspace backing them is on a Premium SKU or Fabric capacity

That last point is the one that changed the game in 2023 and it's still under-appreciated. If your organisation has a Fabric capacity or a Power BI Premium per capacity SKU running, the free users in your tenant can consume reports embedded in Teams without anyone needing to upgrade their licence. For organisations who want to put data in front of frontline staff without buying everyone a Pro licence, this is a sensible pattern. We've rolled it out for a few clients in retail and logistics where the consumers are warehouse and store staff who don't need authoring rights.

What free users cannot do

The big ones:

  • Share content from a non-Premium workspace
  • Collaborate in workspaces with other users
  • Subscribe to reports or dashboards from non-Premium workspaces
  • Use deployment pipelines
  • Schedule data refreshes outside the personal workspace limits
  • Use most of the Power BI mobile app's collaboration features
  • Access workspaces published into Pro-only workspaces

The single most painful one is "share content". A free user can build a report, but they cannot send it to a colleague unless either that report is sitting in a Premium or Fabric backed workspace, or the colleague has a Pro licence. If everyone on your team is free, your data is going to live on a single laptop or in PDF email attachments. We see this pattern in small Australian businesses constantly. The owner is proud of the dashboards they built. None of their staff can see them. The business intelligence layer of the company is effectively one person's hard drive.

The Power BI Pro and Premium per User overview

Power BI Pro is currently around A$15.70 per user per month in Australian pricing (Microsoft adjusts this without much warning, so always check the current sheet). It gets you the right to publish to and consume from any non-Premium workspace, to share reports, to schedule refreshes properly, and to collaborate.

Premium per User (PPU) is around A$31.30 per user per month and adds the larger model sizes, paginated reports, more refreshes per day, and the AI features. For a team of analysts working with reasonable size data, PPU is often the right answer rather than buying a small Premium capacity.

The Fabric SKUs (F2 through F2048) are the capacity based licences. If you've already invested in Fabric for the data engineering side, your Power BI consumers can be free users and still get a full experience. This is the model we recommend more often these days because the economics are usually better once you have more than 50 to 100 consumers in the tenant. We help organisations think through this trade-off in our business AI strategy engagements, because the licencing choice locks in a lot of architectural decisions downstream.

The Microsoft 365 E5 wrinkle

If your organisation is on Microsoft 365 E5, you already have Power BI Pro included for every user. A lot of Australian enterprises on E5 don't realise this and end up double-licencing or buying Pro separately. Worth checking your billing portal before any procurement conversation.

The other wrinkle is that E5 does not include Premium per User. PPU has to be bought as an add-on. The pattern we see in mid-sized organisations is everyone gets Pro through E5, the analysts get PPU on top, and the data engineering function runs on a Fabric capacity. Cleaner and cheaper than trying to give everyone PPU.

Where free users get tripped up

A few practical things we see:

  1. They build a beautiful report and want to put it in Teams. The report is in their personal workspace. Teams won't embed it from there. They have to either republish to a Premium backed workspace (which requires Pro to author) or learn to live with the PowerPoint export.

  2. They set up a scheduled refresh. The free tier allows up to eight refreshes a day in the personal workspace, but only if the data source is supported and the gateway is configured. On-premises data sources need a gateway, and the gateway pattern is the bit that breaks for solo users without IT support.

  3. They share a PBIX file by email. This works once. It does not scale. The data inside the PBIX gets stale the second the sender refreshes their copy. The receivers are reading yesterday's data forever.

  4. They run into the model size limit. The free tier has a 1 GB model size limit per dataset in My Workspace. Most teams don't hit this. The ones who do hit it suddenly and badly, usually around the time the dataset becomes important.

The right call for most Australian organisations

If you're a sole trader or a two person business, the free tier with Power BI Desktop is fine. You're building reports for yourself. You print them or screen share them. Nobody else needs interactive access.

If you're a team of five to twenty, get everyone Pro. The maths is obvious. You'll save more in time wasted on workarounds than you spend on licences in the first month.

If you're fifty plus people and you have a real data engineering function, look hard at a Fabric capacity with your authors on PPU or Pro and your consumers on free. The Fabric capacity does a lot more than just Power BI, and once you're using it for data engineering, the Power BI consumption story becomes cheap.

If you're in the gap between those, that's where the conversation gets interesting. We see organisations stay too long on the free tier because they don't want the cost conversation with finance, and they pay for it in analyst hours doing manual exports. That's the pattern to break. Our Power BI consultants team has had this exact conversation with dozens of Australian businesses. If you want a second opinion on the right licencing shape, get in touch.

A few honest notes

Microsoft has a habit of changing the free tier features quietly. The Teams embedding free user pattern was a meaningful change. The Direct Lake stuff is going to be another. If you read a blog post about Power BI free user features that's more than 18 months old, treat it with suspicion. Including this one once we hit 2027.

Also worth saying: the free tier is not a trial. It does not expire. You can run on it forever. Microsoft makes its money from Pro, PPU, Premium, and Fabric. They are happy to give the desktop tool away. That part is genuine.

If you want the official Microsoft documentation on this, it's here: Features available to free users. It's accurate. It's also written in a way that buries the practical implications. Hopefully this post fills in the gap.