Welcome to deBUG.to Community where you can ask questions and receive answers from Microsoft MVPs and other experts in our community.
0 like 0 dislike
1.3k views
in Power BI by 26 30 36

I know there are many differences between Power BI Desktop Vs Power BI service, but I am wondering Is it possible to configure sharing in Power BI desktop? also, I need to know Which features are available in Power BI Desktop but not in the Power BI service and vice versa?


1 Answer

1 like 0 dislike
by 163 204 403
selected by
 
Best answer

To know the main differences between Power BI Desktop Vs Power BI Service, let's first explain What's Power BI Desktop and What's Power BI Service?

What's Power BI Desktop?

Power BI Desktop is an application that you download and install for free on your local computer. Desktop is a complete data analysis and reports creation tool that is used to connect to, transform, visualize, and analyze your data.

What's Power BI Service?

The Microsoft Power BI service (app.powerbi.com), sometimes referred to as Power BI online, is the SaaS (Software as a Service) part of Power BI. In the Power BI service, dashboards help you keep a finger on the pulse of your business. Dashboards display tiles, which you can select to open reports for exploring further. Dashboards and reports connect to datasets that bring all of the relevant data together in one place.

Generally, Power BI Desktop is more powerful and flexible than Power BI Service, however, there are many features that you can only do with Power BI Service.


Comparing Power BI Desktop and the Power BI service

The below diagram called Venn diagram shows you Which features are available in Power BI Desktop but not in the Power BI service.

Power BI Desktop Vs Power BI Service

What you can do with Power BI Desktop and Power BI service?

Below are some of the features, you can do with both Power BI Desktop and Power BI Service including the following:

  1. Creating Power BI Reports.
  2. Perform Data Visualization.
  3. Manage Security.
  4. Applying Filters.
  5. Configuring bookmarks and selections.
  6. using Q&A and R Visuals.
  7. Visual Interactions
  8. Adding shapes and buttons
  9. Performing refresh.
  10. Duplicate Pages.
  11. Add and remove visuals.

What you can do with Power BI Desktop?

Below are some of the features, you can do with Power BI Desktop but you can't do with Power BI Service including the following:

  1. Many data sources are available.
  2. Performing Data Transformation.
  3. Performing Data Modeling.
  4. Creating Calculated Columns and Measures.
  5. Using Python
  6. Adjust Themes.
  7. Creating RLS (Row Level Security)
  8. Export to Power BI Template

What you can do with Power BI Service?

Below are some of the features, you can't do with Power BI Desktop but you can do with Power BI Service including the following:

  1. Creating dashboards from reports
  2. Creating and managing workspaces
  3. Embed reports
  4. Manging tenant settings
  5. Sharing settings
  6. Dataflow creation
  7. RLS management
  8. Gateway connections
  9. Pagination reports
  10. Export to PowerPoint

See also Comparing Power BI Desktop and the Power BI service

by 26 30 36
0 0
Awesome answer, thank you
If you don’t ask, the answer is always NO!
...