The verdict in three sentences
For a mid-market CFO who consolidates four sources (ERP, CRM, payroll, bank) in Excel every month, Power BI remains the best choice in 7 cases out of 10: about EUR 13 per user per month (Pro, roughly USD 14 or CAD 19) plus EUR 8,000 to 25,000 to set up. A custom dashboard at EUR 20,000 to 60,000 only makes sense if you distribute it to clients, franchisees or dozens of external users, or if your consolidation rules fall outside the standard. Either way, the data warehouse (EUR 50 to 500 a month) is what makes the difference and what lets you save about 3 days on the monthly close.
Power BI or custom: the 2026 comparison
| Criterion | Power BI (Pro or Premium Per User) | Custom dashboard |
|---|---|---|
| Licence | About EUR 13/user/month (Pro), about EUR 22 (Premium Per User) | No licence, hosting EUR 30 to 200/month |
| Setup | EUR 8,000 to 25,000 | EUR 20,000 to 60,000 |
| Lead time | 4 to 8 weeks | 8 to 16 weeks |
| External users (clients, subsidiaries) | Costly and complex | Native, no per-seat cost |
| Finance team autonomy | High (self-service reports) | Limited to planned views |
| Interface customisation | Medium | Full, to your brand |
| Vendor dependency | Microsoft 365 | None, source code delivered |
| Annual maintenance | 10 to 15 % of project | 15 to 20 % of project |
The maths is simple for 15 internal users: 15 × EUR 13 × 12 = EUR 2,340 a year in licences. It would take more than 10 years of licences to match the setup gap with a custom project. Conversely, with 200 franchisees to equip, licences would cost EUR 31,200 a year and custom becomes profitable in under two years.
The real work: the data warehouse and connectors
The closing gain does not come from charts. It comes from automated extraction and data quality. A CFO who keeps manual Excel exports as sources will get a nice dashboard and a close that is just as long.
| Source | Typical connector | Difficulty | Indicative integration cost |
|---|---|---|---|
| ERP (Sage, NetSuite, Dynamics, SAP Business One) | API or database extraction | Medium to high | EUR 2,000 to 8,000 |
| CRM (HubSpot, Salesforce) | Native API | Low | EUR 800 to 2,500 |
| Payroll (ADP, Ceridian Dayforce, Wagepoint) | Scheduled export or API | Medium | EUR 1,000 to 3,500 |
| Banks (statement files or aggregator) | Open banking aggregator or BAI2/CAMT files | Medium | EUR 1,000 to 3,000 + EUR 50 to 150/month |
| Data warehouse (Azure SQL, BigQuery, Snowflake, PostgreSQL) | Cloud hosting | Depends on volume | EUR 50 to 500/month |
| Consolidation model (intercompany, adjustments) | Coded business rules | High | EUR 3,000 to 12,000 |
For a company with EUR 50M to 150M in revenue, the warehouse usually stays under EUR 200 a month. Budget EUR 1,000 to 2,000 to document the data dictionary, which is essential during an audit or a CFO handover.
Mini case study
Daniel, CFO of a food distribution group in Toronto (EUR 68M in revenue, 3 subsidiaries), ties up 3 people for 8 working days every close, including 3 days of manual consolidation. He picks Power BI for 18 users, with an Azure SQL warehouse and 4 connectors: EUR 21,000 setup, EUR 2,810 a year in licences and EUR 1,800 a year in hosting.
Gain: 3 days × 3 people × 12 closes = 108 person-days a year. At EUR 420 per loaded day, that is about EUR 45,400 a year. First-year cost: 21,000 + 2,810 + 1,800 = EUR 25,610. Payback in about 7 months, before counting the value of weekly margin tracking per subsidiary.
Need a professional website?
Kolonell builds websites that attract clients, optimized for the Sénégalese market. Free quote in 2 minutes.
FAQ
Is Power BI enough for multi-entity consolidation?
Yes for 2 to 10 entities with simple intercompany eliminations modelled in the warehouse. Beyond that, or with currency translation and minority interests, a dedicated consolidation tool or a custom model at EUR 8,000 to 12,000 becomes necessary.
Do we need a Premium licence?
Rarely for a mid-market company. The Pro licence at about EUR 13 a month covers most internal uses; Fabric or Premium capacity is justified beyond 300 viewers or for very large data volumes.
How long until we save the 3 closing days?
The first gains appear from the second close after go-live, 2 to 3 months after project start. The 3-day target is usually reached by the fourth close.
Who maintains the dashboard afterwards?
With Power BI, a trained financial analyst (2 to 3 days of training, EUR 1,500 to 2,500) handles new reports. Connectors and the warehouse stay under a maintenance contract at 10 to 15 % of the project per year.
Is custom more secure?
Not inherently. Power BI inherits Microsoft 365 security (strong authentication, row-level security). A custom dashboard can match it, provided you budget a EUR 2,000 to 5,000 security audit.
Let's scope your project. List your data sources, number of users and current closing time: we will compare Power BI and custom for your case, with an indicative budget of EUR 8,000 to 60,000 and a 4 to 16 week timeline. Detailed quote within 48 h. WhatsApp +221 77 596 93 33.
Mohamed Bah
Fondateur, Kolonell
Passionate about digital and entrepreneurship in Africa, Mohamed has been helping Sénégalese businesses with their digital transformation since 2020. Founder of Kolonell, he believes every SME deserves a professional and accessible online présence.
