Comparing Power BI Desktop and the Power BI service

In a Venn diagram comparing Power BI Desktop and the Power BI service, the area in the middle shows how the two overlap. Some tasks you can do in either Power BI Desktop or the service. The two sides of the Venn diagram show the features that are unique to the application and the service.

Venn diagram of Power BI Desktop and service

Power BI Desktop is a complete data analysis and report creation tool that you install for free application on your local computer. It includes the Query Editor, in which you can connect to many different sources of data, and combine them (often called modeling) into a data model. Then you design a report based on that data model. The Power BI Desktop getting started guide walks through the process.

The Power BI service is a cloud-based service. It supports light report editing and collaboration for teams and organizations. You can connect to data sources in the Power BI service, too, but modeling is limited.

Most report designers who work on business intelligence projects use Power BI Desktop to create reports, and then use the Power BI service to distribute their reports with others.

Report editing

In both the application and the service, you build and edit reports. A report can have one or many pages, with visuals and collections of visuals. Add bookmarks, buttons, filters, and drillthrough, to enhance navigation in your reports.

Editing a report in Power BI Desktop or in the service

The report editors in Power BI Desktop and in the service are similar. They're made up of three sections:

  1. The top navigation bars, different in Power BI Desktop and the service
  2. The report canvas
  3. The Fields, Visualizations, and Filters panes

This video shows the report editor in Power BI Desktop.

Working in the Power BI service

Collaborating

After you've created your reports, you can save them to a workspace in the Power BI service, where you and your colleagues collaborate. You build dashboards on top of those reports. Then, you share those dashboards and reports with report consumers inside and outside your organization. Your report consumers view them in the Power BI service in a Reading view, not Editing view. They don't have access to all the features available to report creators. You can also share your datasets and let others build their own reports from them. Read more about collaborating in the Power BI service.

Self-service data prep with dataflows

Dataflows help organizations unify data from disparate sources and prepare it for modeling. Analysts can easily create dataflows, using familiar, self-service tools. Analysts use dataflows to ingest, transform, integrate, and enrich big data by defining data source connections, ETL logic, refresh schedules, and more. Read more about self-service data prep with dataflows.

Next steps

What is Power BI Desktop?

Create a report in the Power BI service

Basic concepts for report designers

More questions? Try the Power BI Community