Power BI Desktop and Service
Understand the difference between Power BI Desktop and Power BI Service, learn how they work together, and discover how reports move from development to sharing.
1. What Is Power BI Desktop?
Power BI Desktop is a Windows application used to create data models and interactive reports. It is generally where a report developer starts working with data.
You can connect to files and databases, clean and transform data, create relationships between tables, write calculations using DAX, and design report pages containing charts and tables.
Example for Beginners
Suppose Neha receives an Excel file containing sales information. She opens Power BI Desktop, imports the file, checks the data, creates a sales chart, and builds a report showing sales by product and month.
She can save the report as a Power BI Desktop file with the .pbix extension.
Common tasks in Power BI Desktop
- Connect to supported data sources.
- Clean and transform data with Power Query.
- Build data models and table relationships.
- Create calculated columns and measures using DAX.
- Design report pages and interactive visualizations.
- Save report development work in a PBIX file.
2. Understanding the Desktop Workspace
Power BI Desktop includes different views that help you work with report pages, data, and relationships. The available interface may vary slightly by version and settings.
Visual 1: A simplified illustration of the report canvas, visualization tools, and data fields.
Three important views
| View | Purpose |
|---|---|
| Report view | Create report pages and arrange visualizations. |
| Table/Data view | Inspect loaded table data and columns where supported. |
| Model view | Inspect and manage relationships between tables. |
3. What Is Power BI Service?
Power BI Service is Microsoft's online analytics service. Users access it through a web browser to view and work with Power BI content according to their permissions.
Once a report has been published, authorized users can access it in the Service. Teams may use workspaces to organize content and distribute reports through supported sharing methods.
Example for Beginners
After building a sales report in Desktop, Neha publishes it to a workspace in Power BI Service. Her manager can then open the report online if the required access and licensing conditions are satisfied.
Common tasks in Power BI Service
- Access published reports and semantic models.
- Organize content in workspaces.
- Share reports with authorized users.
- Create dashboards from supported report content.
- Configure scheduled refresh when supported and required.
- Manage access and permissions according to organizational policies.
4. How Desktop and Service Work Together
Desktop and Service are connected parts of the Power BI workflow. Desktop is commonly used to build the report, while Service is used to publish, access, and distribute it.
Visual 2: The usual development and publishing workflow.
- Connect to the required data in Power BI Desktop.
- Prepare the data and create the report.
- Save your work as a PBIX file.
- Publish the report to a suitable workspace in Power BI Service.
- Grant the appropriate access so intended users can view it.
5. Power BI Desktop vs Power BI Service
| Feature | Power BI Desktop | Power BI Service |
|---|---|---|
| Where it runs | Windows desktop application. | Online service accessed through a browser and supported experiences. |
| Main purpose | Develop data models and reports. | Publish, access, organize, and share content. |
| Data preparation | Power Query is commonly used to transform data. | Supports refresh and other online data management features. |
| Report development | Full report authoring environment for many common tasks. | Online report editing is available for supported scenarios. |
| Collaboration | Primarily local development. | Workspaces, sharing, and collaboration features. |
| Typical file | .pbix | Published Power BI content stored in the Service. |
6. Understanding the PBIX File
A .pbix file is a Power BI Desktop report file. Depending on how the report is built, it can contain report definitions, model information, and imported data.
Visual 3: A simplified view of the elements associated with a PBIX file.
Beginner tips for saving files
- Use a descriptive file name, such as SalesReport.pbix.
- Save your work regularly while developing a report.
- Keep backup copies when making significant changes.
- Remember that a local PBIX file and a published online report are not the same thing.
7. What Happens After Publishing?
Publishing transfers supported report content from Desktop to a destination in Power BI Service. After publishing, the online report can be managed according to the workspace's capabilities and permissions.
Example: A Sales Manager
Omkar builds a report containing sales by region. He publishes it to his organization's approved workspace. His manager opens the published report in a browser and uses the available filters to examine a particular region.
If the source data changes, the report's data may need to be refreshed. The exact refresh method depends on the source, credentials, connectivity, and configuration.
8. The Publishing Cycle
Visual 4: From report development to online access.
9. Beginner Practice Questions
Q1. Which application is commonly used to create Power BI reports?
Answer: Power BI Desktop.
Q2. What is Power BI Service?
Answer: Microsoft's online service for accessing, publishing, organizing, and sharing Power BI content.
Q3. What is a PBIX file?
Answer: A Power BI Desktop file that stores report content and associated model information, depending on the report.
Q4. Does publishing automatically make a report public?
Answer: No. Access depends on permissions, sharing settings, licensing, and organizational configuration.
Q5. Why might a published report need a refresh?
Answer: To retrieve updated source data when refresh is required and supported by the source and configuration.
Summary
Power BI Desktop is commonly used to prepare data, build models, write calculations, and create report pages. Power BI Service is used to publish, access, organize, and share content online.
You learned about Desktop views, the PBIX file, the publishing workflow, and why permissions and refresh configuration matter after publication.