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

  1. Analyst starts a new report
  2. Author model and pages in Power BI Desktop
  3. Publish the .pbix to a workspace in the Service
  4. Must data stay current without manual work? Yes: Configure scheduled refresh in the Service. No: Refresh manually in Desktop and republish.
  5. Share via an app or workspace access
  6. 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 / Apps

Example

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

Power BI topics

Power BI Introduction

Getting Data

Power Query (Data Transformation)

Data Modeling

DAX (Data Analysis Expressions)

Data Visualization

Dashboards & Reports

Power BI Service

Advanced Features

Projects & Case Studies

Interview & Certification

Advanced DAX & Time Intelligence

T
Tech Town
Log InSign Up Free
Home SQL Python DSA Power BI Snowflake Databricks Spark Gen AI Practice Problems Contest Blog

Power BI Dashboards & DAX

Learn data visualization and interactive dashboards step-by-step. Click any topic in the sidebar to open it right here.

{{ sectionCount }}
Sections
{{ topicCount }}
Topics
Free
Forever
Hands-on practice Practice DAX Online 250 business scenarios on a star schema — write a measure and compare your visual with the expected one. Start practising →
Section {{ sec.num }}

{{ sec.label }}

Power BI  /  {{ current.sectionLabel }}  /  {{ current.name }}

{{ current.name }}

Theory

{{ current.def }}

Why we use it

{{ rich.why }}

When to use it

{{ rich.when }}

Diagram

{{ rich.dg.caption }}

{{ tb.title }}
{{ c.v }}
{{ rich.dg.op }}
➜
{{ rich.dg.output.title }}
{{ c.v }}
{{ nd.label }}
{{ nd.sub }}
{{ nd.label }}
{{ nd.sub }}
{{ rich.dg.left.title }}
{{ it }}
{{ rich.dg.right.title }}
{{ it }}
On screen — where to click

{{ rich.ui.title }}

{{ u.text }}
  1. {{ st.n }}{{ st.text }}
{{ rich.ui.title }}
{{ u.text }}
Flowchart — how it works
{{ nd.text }}
{{ nd.text }}
◇ {{ nd.text }}
Yes → {{ nd.yes }}
No → {{ nd.no }}
Syntax / Where to find it
{{ current.syntax }}
Example
{{ current.example }}
What You'll Learn — click to check off
  • {{ pt.mark }} {{ pt.text }}

Share this topic