What does Power BI do for an SME?
Power BI is Microsoft's reporting software. It fetches data from your systems, links that data together and shows the result in a dashboard you can filter and click through. In practice there are two parts:
- Power BI Desktop. The free Windows program in which you fetch the data, create the data model and build the report.
- The Power BI service. The online environment where you publish the report, refresh it automatically and share it with colleagues.
The benefit for an SME is not the good-looking charts. It is that the monthly copying and pasting disappears and everyone looks at the same number. The question "what margin did we make per customer last month?" no longer takes a morning, and the conversation is about the customer rather than about whose Excel file is right.
Is Power BI suitable for a company my size?
Often yes, but not always. Power BI becomes interesting when one or more of these sound familiar:
- Your data sits in more than one system, such as your accounting software, your CRM and a planning tool.
- Someone spends hours every month on the same overview.
- Colleagues come up with different numbers for the same subject.
- You want to know what is happening now, not what happened a month ago.
You do not need it if the reporting in your software does what you want, if one person keeps one overview that works fine, or if you only need the figures a few times a year. Not sure? Excel or Power BI explains how to weigh it up. Company size is not the deciding factor, by the way. A business with ten employees and four systems can get more out of it than a business with fifty employees and one package.
What do you need to get started with Power BI?
Less than you might think. This is the complete list:
- One question. Preferably one with a decision attached. "Which customers bring in too little margin?" is a good question. "We want more insight" is not.
- Access to your data. A login or API key for your software, and someone who knows how the data is stored in it. Excel and databases connect directly. For many accounting and CRM packages you need to check per package whether a ready-made connector exists. If not, it runs through the API or a layer in between.
- A Microsoft work account. You sign up with a work address. A personal address such as Gmail or Outlook.com does not work.
- A Windows computer. Power BI Desktop does not run on a Mac. Viewing reports works fine in the browser, so only the builder needs Windows.
- Licences. For almost every SME this means Power BI Pro for everyone who builds or views reports. More on that below.
- An owner. Someone inside your company who knows the process, checks the results and stays the point of contact after handover. This does not have to be a technical person.
What you do not necessarily need: a data warehouse, an IT department or perfectly clean data. Mess in your data surfaces by itself once you see the first figures, and then you also know which mess matters.
How do you build your first Power BI dashboard?
This order works, whether you do it yourself or have it done:
- Choose the question and record the definitions. What is revenue: invoiced, paid or booked? Write it down before you start building. For ideas on the figures, see the 10 KPIs every SME dashboard needs.
- Find out where the data lives. Which systems, which tables, and which system is leading when two sources differ?
- Fetch the data and build the model. Link customers, products and periods and add a date table. This is the least visible work and also the most important. If you start with your financial figures, also read Connecting Power BI to your accounting software.
- Build one overview page. A few key figures at the top, the trend over time below and one detail page to click through to. Leave the rest out for now.
- Check with the people who know the numbers. Compare the result with your accounts and investigate every difference before anyone else sees the dashboard.
- Publish and schedule the refresh. Put the report in a workspace, set up the refresh and agree who gets notified if it fails.
Two technical points to know upfront. With Pro you can refresh automatically up to eight times a day, which is plenty for most SME reports. And if your source sits on your own server rather than in the cloud, you need a gateway so Power BI can reach it.
Example: an installation company with 12 users
A fictional example. An installation company with thirty employees wants to know which projects make money. Invoices are in the accounting software, hours in a planning tool. Each month the back office puts the two side by side in Excel, which takes a full day.
- The question: what is the margin per project, and on which projects are the hours getting out of hand?
- The definitions: revenue is what has been invoiced, costs are hours times a fixed internal rate plus purchases per project.
- The first version: one overview page with margin per project and per month, plus a detail page per project.
- The licences: one builder and eleven viewers, so 12 x €12.10 = €145.20 per month, or €1,742.40 per year excluding VAT.
During the check it turns out that some hours are booked to a catch-all project. That makes some projects look more profitable than they are. That is not an error in the dashboard, but the dashboard is what brings it to light. The team agrees how hours are booked from now on, and only then does management get to see it.
What does Power BI cost an SME?
The list prices on Microsoft's Dutch website (as of 4 November 2026, excluding VAT, on an annual subscription):
- Power BI Desktop: free.
- Power BI Pro: €12.10 per user per month.
- Premium Per User: €20.80 per user per month.
Note that viewers need a licence too. Viewing for free is only possible on Fabric capacity F64 or higher, which is far too large for most SMEs. What this means for your situation can be worked out with the calculator in What does Power BI cost in 2026? The differences between the licences are covered in Power BI licensing in 2026.
The licence is usually not the largest item. That is the set-up: connecting your sources, building the data model and checking the figures. It depends on the number of sources and the state of your data, not on the number of users.
Can you set up Power BI yourself, or do you need help?
For a report on one source, such as a tidy Excel file, a colleague who enjoys it and is given time for it can get quite far. Microsoft offers free training material and the first chart is up quickly.
It gets harder when you combine several systems, when a connection needs to be built or when the whole company is going to steer by the numbers. Then the data model and formulas take experience. A middle way is also possible: have the connections and model built, and create the reports on top yourself. What to look for when choosing a partner is covered in Hiring a Power BI consultant.
Where does a first Power BI project usually go wrong?
- Starting with everything at once. Finance, sales and HR in one project means nothing is in use for months. One question first.
- No agreement on definitions. If revenue in the dashboard differs from revenue in the accounts, nobody trusts the number any more.
- Forgetting the licences. The report is finished and colleagues are asked to upgrade their licence when they open it. Sort this out upfront.
- Leaving the report in someone's personal workspace. If that colleague leaves, you have a problem. Use a shared workspace with two admins.
- Exports as a permanent source. Manually exported files are fine for testing, but the monthly copying has not gone away. Eventually you want a fixed connection, and with more sources also a data foundation.
Help with your first Power BI dashboard
We build Power BI dashboards for SMEs, on the data you already have. We start with a free introductory conversation and agree what each KPI means. You then receive a proposal with a fixed price per phase, so you can start small with one dashboard for one question. At handover you get documentation and an explanation, including access and admin rights. Maintenance afterwards is optional.
Read more about dashboarding and our approach. The systems we can connect to Power BI are listed under integrations. If your data first needs to be brought together, that falls under data engineering.
