Insights · Data
Power BI vs Data Studio vs Metabase for Nepali teams
The short version
Short answer: if your data already lives in Google Sheets and you want something free by Friday, use Data Studio (formerly Looker Studio). If your office runs on Excel, Windows and Microsoft 365, Power BI is the stronger tool, at $14 per user a month. If you want your data on your own server, or you need to share dashboards widely without paying per viewer, self-hosted Metabase is the one to look at.
That's the headline. The rest of this post is the detail that decides it for a Nepali team: what each one actually costs in rupees, how it handles Tally exports and Bikram Sambat dates, who can see a report without a licence, and how hard each is to learn. We covered what the whole dashboard project costs, build effort included, in what a business dashboard really costs a Nepali SME. This one is only about picking the tool.
What changed with Looker Studio this year?
Google renamed it. On 16 April 2026, Google's release notes said Looker Studio had been rebranded as Data Studio, the name it carried until 2022. The paid tier is now Data Studio Pro. Nothing about the free product's core changed: same reports, same connectors, same sharing. If you search for Looker Studio help, most of it still applies.
Pricing moved elsewhere. Microsoft raised Power BI Pro from $10 to $14 per user a month in April 2025, and Premium Per User from $20 to $24. Metabase's open source edition is still free to self-host, and its cloud Starter plan is $90 a month on yearly billing with five users included. So one tool got a new name, one got more expensive, and one stayed where it was.
How do the three compare on what Nepali teams actually need?
We compared them on the questions that come up in real Kathmandu offices, not on feature checklists. Tap a row for the detail behind it.
Power BI vs Data Studio vs Metabase
The questions that decide it for a small or mid-sized Nepali team.
| Criterion | Power BIMicrosoft | Data Studioformerly Looker Studio | Metabaseopen source or cloud |
|---|---|---|---|
| Cheapest paid licence (US$ per user per month) | 14 USD | 9 USD | 6 USD |
| Free option that is actually usable | PartlyBuild for yourself only; sharing needs Pro | ✓Full reports and link sharing | ✓Open source, self-hosted, unlimited users |
| Excel and Google Sheets | Excel: excellentSheets via connector or export | Sheets: excellentExcel via upload or Sheets | Via a databaseLoad CSV into a database first |
| SQL databases (MySQL, PostgreSQL, SQL Server) | ✓ | ✓ | ✓ |
| Tally data | ODBC or exportNo native connector | Export to SheetsNo native connector | Export to a databaseNo native connector |
| Viewers without a paid licence | ✕Only if content sits on F64 or Premium capacity | ✓Anyone with the link or a Google account | ✓Open source: unlimited users |
| Devanagari text in charts | ✓ | ✓ | ✓ |
| Bikram Sambat dates built in | ✕ | ✕ | ✕ |
| Keep data on your own server | NoMicrosoft cloud; Report Server is a separate licence path | NoGoogle cloud | ✓Self-host anywhere, including a Nepali data centre |
| Learning curve for a non-analyst | Steepest | Easiest | Easy to read, SQL to model |
| Mobile viewing | Native appiOS and Android | Via Looker appOr mobile browser | Mobile browserNo native app |
No tool wins every row. Power BI is the deepest, Data Studio the easiest to share, Metabase the only one you can own outright. Microsoft Power BI pricing page and Microsoft Learn licence guide (Aug 2026); Power BI Blog (Nov 2024); Google Cloud Data Studio release notes (Apr 2026) and Pro overview; Coupler.io (2026); Metabase pricing page (2026). As of 2026-08-28.
Licence prices are list prices in US dollars. Nepali buyers also pay VAT, card fees and an exchange margin.
What does each tool cost in rupees per year?
Per-user prices look small in dollars. Multiply by twelve, then by the team, then by the rupee rate, and the gap between options gets real. We used Nepal Rastra Bank's selling rate of Rs 152.97 per US dollar on 27 August 2026 and the yearly-billing list price for each plan.
Annual licence cost in NPR for 5, 15 and 50 users
Sort any column. Hosting, VAT, card fees and exchange margin are not included.
| Price basis | ||||
|---|---|---|---|---|
| Data Studio (free) | 0 Rs | 0 Rs | 0 Rs | No licence fee |
| Metabase open source | 0 Rs | 0 Rs | 0 Rs | Free licence; you pay for the server |
| Data Studio Pro | 82,604 Rs | 247,811 Rs | 826,038 Rs | $9 per user per project per month, one project |
| Power BI Pro | 128,495 Rs | 385,484 Rs | 1,284,948 Rs | $14 per user per month |
| Metabase Starter (cloud) | 165,208 Rs | 264,638 Rs | 612,645 Rs | $1,080 a year for 5 users, then $65 per user per year |
| Power BI Premium Per User | 220,277 Rs | 660,830 Rs | 2,202,768 Rs | $24 per user per month |
| Metabase Pro (cloud) | 949,944 Rs | 1,049,374 Rs | 1,745,388 Rs | $6,210 a year for 10 users, then $130 per user per year |
Converted at Rs 152.97 per US dollar (NRB selling rate, 27 Aug 2026). Microsoft Power BI pricing (2026); Google Cloud Data Studio Pro overview and Coupler.io (2026); Metabase pricing page (2026); Nepal Rastra Bank forex rate for 27 Aug 2026.
At 50 users, Metabase Starter costs less than half of Power BI Pro, because its per-user add-on is cheaper.
Two things the table hides. First, Power BI's number only covers people who have a licence. If your 50 users are 5 builders and 45 people who just read reports, all 50 still need Pro unless you buy Fabric F64 or Premium capacity, which costs far more. Data Studio and Metabase don't charge viewers that way. Second, Data Studio Pro is priced per user per Google Cloud project, so three people spread across three projects hold nine licences.
Is paying in dollars from Nepal a problem?
It's real friction, not a blocker. All three paid plans bill by international card in US dollars. That means a dollar card or prepaid card from a Nepali bank, an annual foreign-spend limit set by the bank under NRB rules, the bank's exchange margin on top of the NRB rate, and VAT on imported digital services. Annual billing makes one part worse: a single large charge can hit your card limit.
Practical moves: ask your bank about its current limit before you commit, prefer monthly billing if the yearly charge won't fit, or buy through a local Microsoft or Google reseller that invoices in rupees. Self-hosted Metabase sidesteps the question entirely, because there's no licence to pay for.
What about Nepali text and Bikram Sambat dates?
Devanagari is the easy part. All three tools display Unicode Nepali in labels, tables and filters. Test on the cheap Android phones your staff actually use, since a missing font shows up as boxes, not as an error.
Bikram Sambat is harder, and none of the three handles it natively. BS months run 29 to 32 days and change year to year, so you can't convert with a formula. You need a lookup. The common fix, which Power BI users have shared on Microsoft's own community forum since at least 2021, is a date dimension table:
- One row for every Gregorian date you care about, say 2015 to 2030.
- Columns for BS year, BS month number, BS month name (Shrawan, Bhadra and so on), BS day and the Nepali fiscal year, which starts in Shrawan.
- Loaded once from a published BS-AD calendar, then extended each year.
- Every sales, expense or attendance row joins to it on the Gregorian date, so any chart can group by BS month or fiscal year.
Build it once as a table in your database or a Google Sheet and it works in all three tools. It's one of the first things we set up on any Nepali dashboard project.
How does a dashboard actually work, whichever tool you pick?
The tool is only the last step. Every working dashboard follows the same four stages, and where each tool fits depends on the middle two.
Source data to dashboard, and where each tool fits
Tap any box. Power BI can do the model step itself; Data Studio and Metabase lean on a sheet or database for it.
Tap any component above for its role and the real tech.
- Tally books (External, Excel or XML export, or ODBC): Ledgers, receivables and expenses. No BI tool here has a native Tally connector, so data leaves Tally as an export or through its ODBC interface.
- Excel and Google Sheets (External, Files, Drive, OneDrive): Targets, branch reports, manual logs. Power BI reads Excel best, Data Studio reads Sheets best, Metabase wants them loaded into a database.
- Billing or app database (Data, MySQL, PostgreSQL, SQL Server): Where POS, ERP or your own app keeps transactions. All three tools connect to these directly. Point them at a read-only copy, not the live system.
- Reporting database (Data, PostgreSQL or a clean Google Sheet): One place where cleaned tables land: sales, customers, items, one agreed definition per number. Metabase and Data Studio work best when this exists.
- BS date table (Data, One row per day, BS and fiscal-year columns): The Bikram Sambat lookup every fact table joins to. Lets any chart group by Shrawan or fiscal year.
- Power BI semantic model (Service, Power Query + DAX): Power BI can clean and model inside the tool itself, which is why small setups can skip a separate reporting database. It's also why it takes longest to learn.
- Power BI report (Client, Pro or PPU licence): Best for Excel-heavy Microsoft 365 offices and complex measures. Every viewer needs a licence unless you buy capacity.
- Data Studio report (Client, Free or Pro): Best for Google Workspace teams and sharing with outsiders by link. Weaker at heavy modelling.
- Metabase dashboard (Client, Self-hosted or Cloud): Best when you want data on your own server, many viewers, or point-and-click questions over a clean database.
- Scheduled refresh (Queue, Gateway, connector cache or cron job): Power BI needs an on-premises data gateway for local files and databases. Data Studio refreshes through its connector cache. Metabase queries the database live, and a nightly job loads new exports into it.
The model step, not the chart tool, is where most of the effort and most of the errors live.
In plain terms: the source data is whatever you already have. The model is where you clean it, agree what "sales" means and add the BS calendar. The dashboard is the tool on top. Refresh is the schedule that keeps it true without anyone copying and pasting.
Which tool fits which team?
- Google Workspace office, data in Sheets, 5 to 20 people, clients or donors who need to see reports: Data Studio, free tier. Move to Pro only if you need team workspaces or org-owned content.
- Microsoft 365 office, finance team living in Excel, complex measures like margin by branch and month: Power BI Pro. Budget for every viewer's licence, and for the learning time.
- Data that must stay on your own server, such as a cooperative or health provider, or a report read by 100 staff: self-hosted Metabase on a local or cloud server, with someone who can maintain it.
- Mixed tools and no clean database yet: build the reporting database and BS date table first. Then any of the three works, and switching later is cheap.
The last case is the most common one we see. For a sense of the finished result, our executive KPI dashboard case study shows spreadsheet reporting replaced with one live view, and the self-serve analytics rollout covers what happens when sales and marketing can ask their own questions.
What should you do this week?
- Write down where your top five numbers come from today: Tally, a sheet, billing software, a bank statement.
- Count builders and viewers separately. That one split decides whether Power BI's per-user pricing hurts.
- Ask whether any data must stay in Nepal or on your own server. If yes, Metabase moves to the front.
- Try the free option first. Data Studio free and Metabase open source both cost nothing to test with real data.
We build dashboards on all three and don't resell licences for any of them, so we don't mind which one you pick. If you want help choosing, or want the reporting database and BS calendar done properly the first time, see our data visualisation service or talk to the team.
Sources
Frequently asked
Is Looker Studio still free?
Yes. Google renamed Looker Studio back to Data Studio on 16 April 2026, and the standard version still costs nothing. Data Studio Pro, the paid tier, is $9 per user per project per month as of August 2026 and adds team workspaces, organisation-owned content and Google Cloud support. Most small Nepali teams building reports from Google Sheets never need Pro.
Can Power BI, Data Studio or Metabase show Bikram Sambat dates?
None of the three has a built-in Bikram Sambat calendar as of August 2026. The standard fix is a date dimension table: one row per Gregorian day with its BS year, month, day and fiscal year, loaded from a published lookup. Every sale joins to it, so filters and charts can show Shrawan or Poush instead of July or January. It works the same way in all three tools.
Which BI tool is cheapest for a 15-person team in Nepal?
On licence alone, standard Data Studio and self-hosted Metabase open source are both free. After that, at the NRB rate of Rs 152.97 per dollar on 27 August 2026, Data Studio Pro is about Rs 2.48 lakh a year for 15 users, Metabase Starter about Rs 2.65 lakh and Power BI Pro about Rs 3.85 lakh, before VAT and card fees. Self-hosting Metabase moves the cost to a server and someone to maintain it.
Want this run on your numbers?
We'll do the same analysis on one of your workflows in the two-week Automation Sprint.
Related service · Data & Analytics