Getting Started with Power BI Desktop for Property Investors
Power BI sounds technical. It isn't — not anymore, and not the way BI SmartStudio has set it up.
This is a plain-English guide to getting Power BI Desktop installed, connected to your data, and showing you useful numbers. You can do it in under 30 minutes even if you've never used it before.
Why Power BI and Not Excel?
Excel is great for modelling. Power BI is great for tracking. They do different things.
Excel answers: "What will happen if...?" Power BI answers: "What is happening right now?"
If you own one or more rental properties in NZ and you want a dashboard that updates automatically and shows you the current state of your portfolio — yield, cashflow, equity, arrears — Power BI is the right tool.
Step 1: Download Power BI Desktop
Go to powerbi.microsoft.com and download Power BI Desktop. It's completely free. You don't need a Microsoft 365 subscription to use it on your own computer.
Install it like any other Windows application. It takes about 5 minutes.
Note: Power BI Desktop is Windows only. Mac users can run it via a virtual machine, or use the browser version via Microsoft Fabric.
Step 2: Download the BI SmartStudio Dashboard Template
Once you've downloaded Power BI Desktop, you need a template to work from. Building dashboards from scratch takes weeks. Our Rental Performance Studio is already built — you just connect it to your data.
Download the template from your BI SmartStudio account after purchase. You'll receive a .pbix file.
Step 3: Open the Template
Double-click the .pbix file. Power BI Desktop will open it automatically. You'll see the dashboard with placeholder data already loaded.
Step 4: Connect Your Data
The template uses an Excel file as its data source. You'll find a data entry template included in your download package. Fill in your property details in that Excel file — address, purchase price, current value, mortgage details, weekly rent, expenses.
In Power BI Desktop:
- Click Home → Transform data → Data source settings
- Update the file path to point to your Excel file
- Click Refresh
Your dashboard will populate with your real numbers.
Step 5: Refresh and Review
Once connected, hit Refresh in Power BI Desktop anytime you update your Excel data file. The dashboard updates instantly.
You'll see your rental yield, cashflow, equity position, and portfolio KPIs — all current, all accurate, all in one place.
You Don't Need to Be Technical
The template does all the calculation. All you do is enter numbers into Excel, the same way you would a spreadsheet. Power BI handles the rest.
If you get stuck, the setup guide included with the template walks you through every step with screenshots.