Understanding the differences between “Power BI Desktop” and “Power BI Desktop Optimized for Power BI Report Server”


Over the past few weeks, I’ve been spending a lot of time discussing Power BI Report Server with my customers and colleagues. One of the most common questions I’m asked is:

What are the differences between “Power BI Desktop” and “Power BI Desktop optimized for Power BI Report Server”?  

In this blog post, I’ll cover the similarities and differences between Power BI Desktop and Power BI Desktop Optimized for Power BI Report Server (shortened to “Desktop Optimized” for the sake of this article), including the following topics:

  • Why are there two versions?
  • Where do you find the installation media?
  • Are the installation steps the same?
  • Key application differences within the splash screen, options menu, and product functionality

 

Differences between Power BI Desktop and Power BI Desktop optimized for Power BI Report Server

 

Why are there two versions?

With Power BI Desktop, the intended publishing location is the Azure-hosted Power BI Service, which is updated frequently by Microsoft. From this perspective, you can continually upgrade to the monthly Power BI Desktop release and be sure that the reports will work when published to the Power BI Service because updates are being made on both sides.

This model changes with the introduction of Power BI Report Server, where the report server hosting the Power BI reports now resides within your environment. As a result, the server version (PBI Report Server) and the client version (Power BI Desktop optimized for PBI Report Server) need to be controlled a bit tighter to ensure compatibility. The published plan is to release a new version of the server and corresponding Desktop Optimized version roughly every 4 months.

Where do you find the installation media?

Power BI Desktop can be found here: https://powerbi.microsoft.com/en-us/desktop/

The executable name is PBIDesktop.msi (for 32-bit installation) or PBIDesktop_X64.msi (for 64-bit installation).

Power BI Desktop Download Location

Power BI Desktop Optimized for Power BI Report Server can be found under the "Advanced Download Options" link here: https://powerbi.microsoft.com/en-us/report-server/

The executable name is PBIDesktopRS.msi (for 32-bit installation) or PBIDesktopRS_X64.msi (for 64-bit installation).

Power BI Desktop Optimized for Power BI Report Server Download Location

 

Installation Process

During the installation process, there are a few small differences between the versions.

Power BI Desktop does not contain the PBI RS message, while the Desktop Optimized version contains an additional information message on the setup page.

Power BI Desktop Setup Wizard

 

Power BI Desktop Optimized for Power BI Report Server Setup Wizard

 

The default installation path is different for the two versions, with Power BI Desktop defaulting to %PROGRAMFILES%\Microsoft Power BI Desktop\, while Desktop Optimized defaults to %PROGRAMFILES%\Microsoft Power BI Desktop RS\.

Default Installation Path for Power BI Desktop

 

Default Installation Path for Power BI Desktop Optimized for Power BI Report Server

 

Splash Screen

When you launch the two applications, you’ll notice a small, but important, difference on the splash screen, where the Desktop Optimized version allows you to “Open from report server”. By selecting this, you provide the connection information to the Power BI Report Server, where you are then shown the list of reports that you have access to on the server. You can open those directly in PBI Optimized and then publish them back up to the PBI Report Server when finished.

Power BI Desktop Splash Screen

Power BI Desktop Optimized for Power BI Report Server Splash Screen

 

Options Menu

The Power BI options menu is an area of the product where you can make optional changes, such as enabling tracing for troubleshooting, enabling preview features, updating security and privacy settings, etc. By comparing the options menus from the two versions, we see that the Power BI Desktop Optimized version does not include full feature parity. The biggest difference (that I noticed) is that Desktop Optimized does not allow for the use of preview features. My hunch for this goes back to the requirement of keeping the Report Server and the Desktop Optimized version in lock-step for compatibility/stability purposes, while the preview features are in the earlier stage of development and testing until they get moved out of preview and into the standard product.

Power BI Desktop Options Menu

 

Additional Notes

Power BI Desktop Optimized for Power BI Report Server adds a new option to the “Save as” menu, where you can save directly to the Report Server.

Power BI Report Server Save As Dialog 

 

The two versions can be installed on the same machine, with the startup menu labels being slightly different.

Power BI Desktop Startup Labels

 

One additional item of note is that custom visuals are supported in the Power BI Desktop Optimized for Power BI Report Server version, with the same methods of adding the visuals (by web or by file share).

There are likely several other differences that I haven’t encountered yet. If you have discovered any differences not listed here, please share in the comments below and I will update the article.

Thanks,
Sam Lester (MSFT)

 

Comments (12)

  1. Joie Andrew says:

    Nice article! If one doesn’t have Power BI Desktop Optimized for Power BI Report Server installed can one still make a Power BI report in the normal Power BI Desktop and manually upload it to Power BI Report Server, similar to manually uploading rdl files?

    1. Hi Joie, the way I understand the support statement is that you must create reports through Power BI Desktop Optimized for Power BI Report Server in order to publish them to Power BI Report Server. While many of the features of a report created in Power BI Desktop *might* work in PBI RS, it is not a supported option.

  2. Ken Wetherell says:

    Sam, thanks for your article. It is the first I have seen that compares the two versions of Power BI. We use both versions of Power BI Desktop (i.e. one for PBI Service and the other optimized for PBI Report Server). The user experience is the same. The differences did not become known to us until we deployed our .pbix model to the Report Server to support dozens of users in our management (we moved to Report Server due to company IT security policy). The two big differences that are significantly painful for our users are as follows:

    1) Data export row limitation — 150,000 rows in PBI Service vs. 30,000 in PBI Report Server
    2) “Export underlying data” option is not available in PBI Report Server (i.e. it is limited to WYSIWYG data export versus the table details behind a report visual)

    These parity differences cause the solution to be unusable for us in some cases and inefficient for us in others. I hope that Microsoft makes PBI Report Server more powerful in an upcoming release.

    Readers, please “Vote” for the following “Ideas” (i.e. requests) corresponding to the above capabilities!
    1) https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/33156208-increase-the-data-export-row-limit-30-000-rows-ma
    2) https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/32882674-add-underlying-data-option-to-export-data-capabi

  3. Ravi Prasad says:

    Hi Sam, you mention that Power BI Desktop Optimized for Power BI Report Server supports Custom Visuals but when I tried to use a Custom Visual (from Zoomchart) it said this visual is not supported by the PBI Desktop version. I am using the October release of the PBI Desktop optimized for RS. Do you know if I need to do anything different to use custom visual?

    1. Hi Ravi, thanks for the comment. I *believe* that the scenario you are hitting is an issue of the custom visual being updated after (more recently than) the release of the latest Power BI Report Server. In the current case, the latest PBI RS is from October 2017, but the ZoomCharts visuals have been updated in January 2018, thus the mismatch error. If you try it with a custom visual that hasn’t been updated after the PBI RS release, you should see them work as expected. This is a tricky scenario. I’ve started a discussion internally on how to solve this and will update this thread when I receive a resolution or status update.

  4. Sean Smyrke says:

    Hiya,
    Thanks you for your article its clarified a lot for me
    Just wondering if a new version optimized for report server is coming out soon?
    You mentioned that they will be updated once every 4 months but we are still running the one from October 2017. This version doesn’t support chart filtering on drill downs, which is ruining the flow of a lot of my reports.
    This feature has already been added to the cloud PBI

    1. Hi Sean, the latest version (March 2018) was released about a week ago. You can find it here: https://www.microsoft.com/en-us/download/details.aspx?id=56722

      1. Chris Burridge says:

        Hi Sam, nice précis.

        Quick question if I may, when we click the ‘Publish’ button in PBI Report Server desktop version, nothing appears to happen. Could you confirm whether it is possible to publish to the Power BI service from the Report server version?

        We currently deploy to both PBI Service and our on-premise Report Server, so the team currently have to open and deploy in both desktop versions, do you know if a) there is a way to publish to the PBI service direct from the Report Server version or b) are there plans to release a single desktop version that will alow the deployment to both?

        Thanks,
        Chris.

  5. Sara says:

    The information for downloading PBI Desktop for Report Server is wrong. The “Advanced Download Options” link does NOT take you to a page where you can download Desktop for RS.

    1. Hi Sara, it is a bit confusing to find the download for PBI Optimized for RS. The live link in the blog article takes you to a page that appears to be the download for PBI RS (not the Desktop version), but if you expand the Details node in that page, you’ll see PBIDesktopRS_x64.msi and PBIDesktop_x64.msi are available.

  6. Andrzej says:

    Sam, thanks,
    we use Power BI Report Server and PBI Service.
    The latest version Report Server was released in March 2018!
    When will be update Report Server to alignment level of functionality?
    Sincerely,
    Andrzej

  7. Danny Anicama Masgo says:

    Nice Guide!! I Have question related to the PBIRS… how will i be able to learn PBIRS? Can you recommend me some link where i can learn related to PBIRS… becuase i was looking for information but I wasnot be able to get information….

Skip to main content