Power BI Ecosystem (Desktop, Service, Mobile)
Power BI · Power BI Introduction
Theory
Power BI is not one app but a set of surfaces that work together. Power BI Desktop is a free Windows application where you connect to data, transform it, model it and design report pages, saving everything in a .pbix file. The Power BI Service is the cloud site (app.powerbi.com) where you publish that file, organise content in workspaces, schedule refresh, build dashboards and share with colleagues. Power BI Mobile apps for iOS and Android let people view and interact with published reports and dashboards on a phone or tablet.
Installing Desktop is simple: get it from the Microsoft Store (which keeps it updated automatically) or download the installer from Microsoft's Power BI site, then sign in with a work or school account when you are ready to publish. Organisations that must stay on-premises can use Power BI Report Server instead of the cloud Service.
Why we use it
Each surface does one job well: heavy authoring on a desktop, governed sharing and refresh in the cloud, and quick consumption on mobile. Knowing which piece does what avoids confusion such as looking for scheduled refresh inside Desktop.
When to use it
Build and edit models in Desktop; use the Service when others must view the report or data must refresh on a schedule; use Mobile for on-the-go viewing. Mac users cannot run Desktop natively and usually work through a Windows VM or author lighter reports directly in the Service.
How it works
- Analyst starts a new report
- Author model and pages in Power BI Desktop
- Publish the .pbix to a workspace in the Service
- Must data stay current without manual work? Yes: Configure scheduled refresh in the Service. No: Refresh manually in Desktop and republish.
- Share via an app or workspace access
- Users view in browser or Mobile app
Syntax
Desktop: Report / Table / Model views → File → Save (.pbix)
Publish: Desktop → Home → Publish → choose a workspace
Service: app.powerbi.com → Workspaces → open report
Mobile: install the Power BI app → sign in → Favourites / AppsExample
1. Build 'Sales Overview.pbix' in Desktop with the Sales, Customers and Products tables.
2. Home → Publish → workspace 'Sales Analytics'.
3. In the Service, the workspace now holds a semantic model (formerly called a dataset) and a report.
4. Set a daily scheduled refresh on the semantic model.
5. Priya, the North region manager, opens the same report in the Power BI Mobile app on her phone.Key points
- Desktop: free authoring tool for Windows; saves .pbix files
- Service: cloud workspace for publishing, sharing and scheduling refresh
- Mobile: native apps for iOS and Android to view reports and dashboards
- Dashboards are built only in the Service, not in Desktop
- Store install auto-updates Desktop; keep versions in step across the team