Power BI Desktop and Service Capabilities – Complete Guide for DP-900
Why Power BI Desktop and Service Capabilities Matter
Power BI is one of the most widely used business intelligence platforms in the world, and it is a core topic on the Microsoft DP-900: Azure Data Fundamentals exam. Understanding the distinction between Power BI Desktop and the Power BI Service is essential because exam questions frequently test whether you know which tasks are performed where, what capabilities each tool offers, and how they work together to deliver end-to-end analytics solutions.
In real-world scenarios, organizations rely on Power BI to transform raw data into meaningful visualizations and interactive reports. Knowing the capabilities of each component helps data professionals choose the right tool for the right job, making this knowledge valuable far beyond the exam.
What Is Power BI Desktop?Power BI Desktop is a
free Windows application that you install locally on your computer. It is the primary
authoring and development tool for creating Power BI reports. Key capabilities include:
•
Connecting to Data Sources: Power BI Desktop can connect to a vast array of data sources including Azure SQL Database, Azure Synapse Analytics, Excel files, CSV files, REST APIs, on-premises SQL Server databases, and many more.
•
Data Transformation (Power Query): Using the built-in
Power Query Editor, you can clean, shape, merge, and transform data before loading it into the data model. This is often referred to as the ETL (Extract, Transform, Load) process within Power BI.
•
Data Modeling: You can define relationships between tables, create calculated columns and measures using
DAX (Data Analysis Expressions), build hierarchies, and configure data types. The data model is the backbone of any Power BI report.
•
Report Authoring: Power BI Desktop provides a rich drag-and-drop canvas for creating interactive visualizations such as bar charts, line charts, maps, tables, matrices, KPI cards, and custom visuals. You can add slicers, filters, bookmarks, drill-through pages, and tooltips.
•
Publishing: Once a report is complete, you publish it from Power BI Desktop to the
Power BI Service (cloud) so that others can view and interact with it.
•
File Format: Reports created in Power BI Desktop are saved as
.pbix files.
Think of Power BI Desktop as the development environment — where you build everything.
What Is the Power BI Service?The Power BI Service (also called
Power BI Online or
app.powerbi.com) is a
cloud-based (SaaS) platform for sharing, collaborating on, and consuming Power BI content. Key capabilities include:
•
Workspaces: Organize reports, dashboards, and datasets into collaborative workspaces where teams can work together. Workspaces support role-based access control.
•
Dashboards: A
dashboard is a
single-page canvas of pinned visuals (tiles) from one or more reports.
Dashboards can only be created in the Power BI Service, not in Power BI Desktop. This is a frequently tested concept on the DP-900 exam.
•
Sharing and Distribution: You can share reports and dashboards with colleagues, create
Power BI Apps for broader distribution, embed reports in Microsoft Teams, SharePoint, or custom applications, and use
Row-Level Security (RLS) to control data access.
•
Scheduled Data Refresh: The Power BI Service allows you to configure automatic data refresh schedules so that reports always show up-to-date information. You may need a
Power BI Gateway to refresh data from on-premises sources.
•
Natural Language Queries (Q&A): Users can type questions in plain English (e.g.,
"total sales by region last year") and Power BI will generate a visual answer automatically.
•
Alerts and Subscriptions: You can set data-driven alerts on dashboard tiles and subscribe to receive email reports on a schedule.
•
Dataflows: The Power BI Service supports
dataflows, which are cloud-based ETL processes that prepare and store data in Azure Data Lake Storage for reuse across multiple reports and datasets.
•
Paginated Reports: The service supports paginated reports (created in
Power BI Report Builder), which are pixel-perfect, print-ready reports ideal for invoices, statements, and operational reports.
•
Lineage and Impact Analysis: Track data lineage to understand where data comes from and use impact analysis to see what would be affected by changes to a dataset.
Think of the Power BI Service as the consumption, collaboration, and sharing environment — where you distribute and manage everything.
How Power BI Desktop and Service Work TogetherThe typical workflow is:
1.
Connect & Transform – Use Power BI Desktop to connect to data sources and transform the data using Power Query.
2.
Model – Build the data model with relationships and DAX measures in Power BI Desktop.
3.
Visualize – Create reports with interactive visuals in Power BI Desktop.
4.
Publish – Publish the .pbix file from Power BI Desktop to a workspace in the Power BI Service.
5.
Share & Collaborate – In the Power BI Service, create dashboards, set up refresh schedules, share with stakeholders, configure alerts, and build apps.
6.
Consume – End users interact with reports and dashboards via the Power BI Service (web browser) or the
Power BI Mobile app.
Key Differences at a GlancePower BI Desktop:• Windows desktop application (free)
• Full data modeling and DAX authoring
• Full Power Query (ETL) capabilities
• Report creation and design
• Cannot create dashboards
• Single-user authoring tool
• Saves .pbix files locally
Power BI Service:• Cloud-based SaaS (browser)
• Dashboard creation (pinning tiles)
• Sharing, collaboration, and distribution
• Scheduled refresh and gateways
• Q&A natural language queries
• Alerts, subscriptions, and apps
• Workspaces with role-based access
• Dataflows for cloud-based ETL
• Basic report editing (limited compared to Desktop)
Power BI Licensing (Exam-Relevant Basics)•
Power BI Desktop: Free to download and use.
•
Power BI Free (Service): Limited sharing and collaboration; mainly for personal use.
•
Power BI Pro: Per-user license; enables sharing and collaboration across the organization.
•
Power BI Premium: Capacity-based license; allows content to be shared with free users, provides larger storage, dedicated compute, paginated reports, and AI capabilities.
Exam Tips: Answering Questions on Power BI Desktop and Service Capabilities1.
Remember where dashboards are created: Dashboards are
only created in the Power BI Service. If a question asks where to create a dashboard, the answer is always the Power BI Service — never Power BI Desktop.
2.
Know the authoring split: Data modeling, complex DAX measures, and advanced Power Query transformations are primarily done in
Power BI Desktop. Sharing, scheduling refresh, creating apps, and setting alerts happen in the
Power BI Service.
3.
Understand .pbix files: Reports are saved as .pbix files in Power BI Desktop and then published to the service. If a question references .pbix, it is talking about Desktop.
4.
Know what a gateway does: A
Power BI Gateway is required to refresh data from on-premises sources in the Power BI Service. If a question involves on-premises data refresh, think gateway.
5.
Distinguish reports from dashboards: A
report can have multiple pages and is created in Power BI Desktop (or the Service with limited editing). A
dashboard is a single page of pinned tiles and is only in the Service. Questions may try to confuse these two concepts.
6.
Paginated reports use a different tool: Paginated reports are created in
Power BI Report Builder (not Power BI Desktop). They are hosted in the Power BI Service under Premium capacity. Know the difference: paginated reports are for pixel-perfect, printable layouts; interactive reports are built in Desktop.
7.
Q&A is a Service feature: Natural language querying (Q&A) is a feature of the Power BI Service and Power BI Mobile, not of Power BI Desktop.
8.
Think about licensing scenarios: If a question asks how to share content with users who do not have a Pro license, the answer typically involves
Power BI Premium capacity.
9.
Watch for "collaborate" and "share" keywords: When exam questions mention collaboration, sharing, workspaces, or apps, the answer almost always points to the
Power BI Service.
10.
Dataflows are cloud-based: If a question mentions reusable data preparation in the cloud or self-service ETL in Power BI, the answer is
dataflows in the Power BI Service.
11.
Eliminate wrong answers using component knowledge: Many DP-900 questions present four options. If you clearly know that a certain capability belongs to Desktop and not Service (or vice versa), you can quickly eliminate incorrect options and arrive at the correct answer.
12.
Practice scenario-based thinking: The DP-900 often presents short scenarios. Ask yourself:
"Is this person building or consuming?" Building → Desktop. Consuming, sharing, monitoring → Service.
SummaryPower BI Desktop and the Power BI Service are complementary tools that together provide a complete analytics solution. Desktop is where you
build — connect, transform, model, and visualize. The Service is where you
share, collaborate, and consume. Understanding this division of responsibilities, along with key features unique to each tool (dashboards in Service, data modeling in Desktop), is critical for answering DP-900 exam questions accurately and confidently.
