Your business is growing. You’ve implemented Dynamics 365 Sales and Business Central. Your team is making real decisions every week. The problem is, those decisions are based on data that’s three weeks old, stitched together in Excel by someone in finance who’s tired and didn’t finish until 9 PM last Tuesday.
You know your competitor down the road is doing something different. They’re talking about “real-time dashboards” and “AI insights”. You’re wondering if that’s buzzword theatre, or if they actually have something you need.
They do. And it’s cheaper than you think to get there yourself.
What Has Changed (and Why Now)
For the last decade, if you wanted proper analytics across your business, you faced a choice that wasn’t really a choice: buy a separate analytics platform (Tableau, Qlik, Looker). Pay for separate licenses. Wait months for IT to build data pipelines. Hope the consultants who cost £2,000 a day actually understood your business. Deploy on-premises infrastructure or navigate another cloud vendor.
The barrier was financial, technical, and time-based all at once. For UK SMBs, it was simply out of reach.
That changed 18 months ago.
Microsoft Fabric is Microsoft’s answer to “what if we made enterprise analytics a platform, not a product?”. It’s one service that sits in your Microsoft 365 and Dynamics ecosystem. It handles the data movement (no separate ETL tool). It provides the analytics layer (replacing separate BI platforms). It connects to your existing data automatically (OneLake, Microsoft’s unified data storage, sits behind it). And crucially, it shares the same architecture as the new AI capabilities Microsoft is building into everything.
The old world was: analytics platform, data warehouse, business intelligence tool, dashboards, AI layer. All different services, all different vendors, all different bills. The new world is: Fabric.
Why the timing matters is this: the AI capabilities that are changing every business right now (Copilot, natural language queries, predictive insights) only work well if your data is already clean, connected, and in one place. If you build that foundation today with Fabric, you’re not just getting dashboards. You’re building the platform that powers AI insights tomorrow. Same data, same infrastructure, same investment.
What Does It Actually Cost?
Most articles about Fabric pricing are either written by Microsoft or by people who’ve never actually bought Microsoft software. They’re vague. Let me be specific and honest.
The Free Trial Reality
If you want to try Fabric with no commitment and no credit card, you have 60 days and F64 capacity (that’s enough to do real work, not toy work). Here’s how:
1. Go to app.fabric.microsoft.com
2. Click your profile icon → Start Trial
3. Select UK South region → ActivateThat’s it. You have two months to connect your data, build dashboards, and prove whether this is worth paying for. Most SMBs finish their proof of concept in four weeks and spend the last four weeks deciding what to buy.
The Pay-As-You-Go Reality
If you want to keep going after the trial ends (and you probably will), you pay for Capacity Units (CUs). Think of CUs as compute power. You buy a SKU, it gives you a baseline of CUs, you use them for Power BI reports, data pipelines, AI queries, whatever you need. If you run out, you can add more on the same day.
Here’s what the pricing actually looks like in GBP:
| SKU | 24/7 Cost | Business Hours Only | Saving |
|---|---|---|---|
| F2 | £210/mo | £69/mo | 67% |
| F8 | £840/mo | £290/mo | 65% |
| F16 | £1,680/mo | £580/mo | 65% |
The “Business Hours Only” column is the one most SMBs miss. If your analytics work happens Monday to Friday, 8 AM to 6 PM, you pause the capacity outside those hours. You pay 67% less. For F2, that’s £69 a month. For F8, it’s £290.
The Reserved Pricing Reality
If you commit for one year (rather than month-to-month), Microsoft discounts the entire bill by 40%. Combine that with business hours scheduling, and the math becomes very different.
An F8 on reserved pricing with business hours paused outside 9-5 costs approximately £175 per month.
That is less than one day of a contractor’s time per month for an enterprise analytics platform.
Most UK SMBs with between 50 and 300 employees run on F8 reserved plus business hours scheduling. It works because the data refresh and report building happens during work hours anyway. The AI queries (which do run 24/7) get their own smaller SKU if needed, but most don’t.
Connecting Your Existing Microsoft Stack
If you’re running Dynamics 365 Sales or Business Central (or both), this section is why Fabric matters to you specifically.
D365 Sales stores customer interactions, opportunities, activities, and sales history in Dataverse. Business Central stores transactions, invoicing, costs, and margins in its own database. For years, the only way to answer questions across both was to export data from each system, manipulate it in Excel, and hope nobody made a change while you were building formulas.
Fabric changes this. D365 Sales data can flow into Fabric through Fabric Link, which is a connection that moves your Dataverse tables into OneLake (Microsoft’s unified data lake). There’s no ETL, no pipeline configuration, no data engineering degree required. You tick a box and your data starts flowing. For Business Central, you connect via Dataverse sync (the preferred method for modern implementations) or via direct OData APIs.
For the first time, you can answer real questions. Not “how much revenue did we invoice last month?” (Business Central answers that). Not “what’s our pipeline this quarter?” (Sales answers that). But “which opportunities in my CRM actually converted to profitable invoices in Business Central?” That’s a new question. That’s the business question. And suddenly, your data can answer it.
This is the part where most analytics platforms fall apart. They’re great at one system or the other, but putting two enterprise systems in the same analytical layer and having them actually talk? That requires unified data storage (OneLake) and a platform that’s built around it (Fabric). It’s not easy. Fabric makes it as easy as it’s going to get.
The AI Angle - Why This Matters Right Now
Here’s the conversation most UK business leaders are having right now: “AI is important, but we don’t know if it applies to us. We don’t have massive data science teams. We just need to run our business.”
Fair point. Except your business already has the hardest part solved: data.
Every email your sales team sends in D365 Sales is logged. Every customer phone call gets tagged. Every invoice in Business Central knows when it was paid (or not paid). Every order has margin information attached. That’s data. Mountains of it. And that’s data is where AI actually works.
But here’s the catch: Copilot in Fabric only works well if your data is clean, connected, and in one place. It doesn’t work against three separate systems with no relationships between them. It doesn’t work against Excel spreadsheets. It works against unified, structured data in OneLake.
The compounding effect is this: the analytics foundation you build today (the Power BI reports, the data model, the connections between Sales and Business Central) becomes your AI foundation tomorrow. You don’t rip it out and rebuild it. You ask Copilot questions against the same data structure. “Which of my open opportunities are at risk based on similar historical deals?” or “Which customers are showing early signs of churn based on order frequency changes?” or “What is my realistic revenue forecast for next quarter based on pipeline plus seasonal Business Central patterns?”
These aren’t hypothetical queries. They’re the questions you should be asking your business every week. And you’re not asking them now because the infrastructure to answer them didn’t exist at SMB budgets.
One honest note: the Copilot features in Fabric do require F64 capacity. For most SMBs, the right approach is to start with F8 for your analytics work (reports, dashboards, data models). Prove the value. Show the team what better data visibility actually does to decision-making. Then, when the business case for AI queries is clear and the data foundation is solid, you have an upgrade path. It’s not a restart.
What a Real Trial Looks Like
The 60-day free trial can feel overwhelming if you don’t have a plan. Here’s what a realistic UK SMB trial actually looks like:
Week 1-2: Foundation
- Activate Fabric trial (UK South region)
- Enable Fabric Link for Dataverse (D365 Sales tables)
- Connect Business Central via Dataverse sync
- Validate data is flowing into OneLake
This should take a morning. If it takes more, you’ve probably hit a permissions issue with your Microsoft 365 admin. Have them give you Power Platform admin rights (or at least Fabric admin rights) temporarily. This is the only thing that might need IT help. The rest is you clicking buttons.
Week 3-4: First Report
- Build unified Sales Performance dashboard
- Pipeline from D365 Sales (opportunities by stage)
- Invoiced revenue from BC (revenue by month, profit margin)
- Customer profitability (CRM activity level vs BC margins)
- Share the dashboard with 2-3 business stakeholders
- Gather feedback (do they trust it, does it match what they thought they knew?)
This takes a week if you’ve never built a Power BI report. It takes 2-3 hours if you have. The data model is already done (Dataverse and Business Central structures are known), so it’s just connecting fields and building the visual. Share with the Sales Director, Finance Manager, and your MD. Ask them: “Is this what you wish you had?”.
Week 5-8: Prove the Value
- Identify one manual reporting process this dashboard replaces
- Quantify the time saved (e.g., “Finance spends 4 hours every Friday on this report” = £200 per week in salary cost)
- Monitor Capacity Unit consumption to understand what you’ll actually pay
- Build ROI case for production investment
This is where you decide whether to convert to a paid SKU. If you’ve found one reporting process that takes 2-3 hours a week to do manually, and a dashboard replaces it, then at F8 reserved pricing (roughly £175/month), you’ve paid for the platform in the cost of one person’s time by week three.
Most SMBs find three or four of these processes in the trial. By week eight, they’ve already decided it’s worth buying.
The Real Question
The question is not whether your business needs better data analytics. You do. Every business does. The question is whether you act before your competitors do, and whether you build that foundation while your team still has the capacity to learn something new.
The 60-day free trial removes every financial reason to delay. It removes the credit card risk. It removes the commitment. The only reason not to start is inertia, and inertia is expensive.
Your decision today isn’t really about Fabric. It’s about whether you want your team making decisions based on data from last week or data from now. Everything else follows from that.
