Power BI Desktop Download or Microsoft Store App? Which One?

FacebooktwitterredditpinterestlinkedintumblrmailFacebooktwitterredditpinterestlinkedintumblrmail
FacebooktwitterlinkedinrssyoutubeFacebooktwitterlinkedinrssyoutube

If you want to develop Power BI reports, you’ll need the Power BI Desktop application. However, Power BI Desktop application comes in two ways; Download it separately and install it on your Windows machine, or Get it from Microsoft Store as an App. The question that I often get is; What is the difference? which one is better? Let’s talk about that in this post.

Power BI Desktop: Report Authoring Tool

Power BI Desktop is a tool that every Power BI Developer needs to build Power BI reports. This tool is FREE.

When you open Power BI Desktop for the first time, there is a pop-up window, which will ask you to log in, but that is not mandatory. You can use Power BI Desktop without any account, username or login credentials.

Power BI Desktop in Microsoft Store

One of the ways to download Power BI Desktop is to get it from Microsoft Store.

Again, that doesn’t mean you need to pay for it. All you need is a Microsoft account (which can be live account) to be able to access apps from the store, and the Power BI Desktop app is free;

As you see in the screenshot below, Power BI Desktop can be searched in the Microsoft Store, and easily downloaded. I have this already installed through Microsoft Store, and that is why I see it is mentioned “Launch” instead of download in the below screenshot;

You can use this option easily if you have Windows 10 on your machine.

Power BI Desktop; Separate Download Link

Another way to get Power BI Desktop is to download it from this link.

You can simply download the file and install it on your machine.

Auto-Update: Microsoft Store App

Now that you know the two methods that Power BI Desktop can be available, let’s see the difference. The first difference is that the Microsoft Store version of Power BI Desktop updates automatically. As soon as a new update is available from Power BI Team, the application automatically updates itself to the latest version and you don’t need to do any extra actions to keep it up-to-date.

Power BI team updates the Power BI Desktop tool every month, and keeping that manually up-to-date is a big hassle. So if you want to be always on the edge of updates and enjoy the fascinating new features announced every month, considering getting the Power BI Desktop from the Microsoft Store.

Flexibility on Install: Download Link

One of the problems of the Microsoft Store version of Power BI Desktop is that it is not available for all versions of Windows. For some versions, you can only use the download link. Another scenario is that for some reason, someone might want to use an older version of Power BI Desktop for their report development work. Using the Microsoft Store app wouldn’t allow it usually, because it automatically updates. so you will have more flexibility on what you want to have installed and where you want this to be installed using the download link.

Development Work: Both the Same

In terms of building the report, there is no difference between the two versions (if we consider that both versions are up-to-date). You can build exactly the same report using any of these two methods. There will be no difference in the Power BI file (*.PBIX file) that is created using any of these methods. You can open a file created with any of these, using the other one (as long as they are both up-to-date).

Power BI Desktop Report Server is Different

There is another tool with almost the same name as Power BI Desktop but called as Power BI Desktop Report Server. This is the report development tool that only supports reports to be published into Power BI Report Server (which is an on-premises solution for Power BI). This tool is only available through a download link, and there is not Microsoft Store app version for that yet. This tool gets updated every four months, and some of the features of Power BI Desktop is not available for it. To learn more in detail about their differences read my article here.

Summary

In summary, there is no difference in developing reports between the two different methods of accessing Power BI Desktop as long as they are both up-to-date. The Microsoft Store version of Power BI Desktop gives you a hassle-free auto-update, versus the download link, gives you the flexibility to install it everywhere you want. Power BI Desktop Report Server is also a version of the application used to build reports for the on-premises version of Power BI.

Video

FacebooktwitterredditpinterestlinkedintumblrmailFacebooktwitterredditpinterestlinkedintumblrmail
FacebooktwitterlinkedinrssyoutubeFacebooktwitterlinkedinrssyoutube
Reza Rad on FacebookReza Rad on LinkedinReza Rad on TwitterReza Rad on Youtube
Reza Rad
Trainer, Consultant, Mentor
Reza Rad is a Microsoft Regional Director, an Author, Trainer, Speaker and Consultant. He has a BSc in Computer engineering; he has more than 20 years’ experience in data analysis, BI, databases, programming, and development mostly on Microsoft technologies. He is a Microsoft Data Platform MVP for nine continuous years (from 2011 till now) for his dedication in Microsoft BI. Reza is an active blogger and co-founder of RADACAD. Reza is also co-founder and co-organizer of Difinity conference in New Zealand.
His articles on different aspects of technologies, especially on MS BI, can be found on his blog: https://radacad.com/blog.
He wrote some books on MS SQL BI and also is writing some others, He was also an active member on online technical forums such as MSDN and Experts-Exchange, and was a moderator of MSDN SQL Server forums, and is an MCP, MCSE, and MCITP of BI. He is the leader of the New Zealand Business Intelligence users group. He is also the author of very popular book Power BI from Rookie to Rock Star, which is free with more than 1700 pages of content and the Power BI Pro Architecture published by Apress.
He is an International Speaker in Microsoft Ignite, Microsoft Business Applications Summit, Data Insight Summit, PASS Summit, SQL Saturday and SQL user groups. And He is a Microsoft Certified Trainer.
Reza’s passion is to help you find the best data solution, he is Data enthusiast.

4 thoughts on “Power BI Desktop Download or Microsoft Store App? Which One?

  • Hi Reza,

    Thank you for the comparison 🙂

    There is one difference though between the two versions, that has always puzzled me. For some reason it is not possible to drag and drop query steps and queries in the App Store version. Here you need to manually click ‘move up/down’ to change the position… but in the manual download option this is possible. At least this is my experience in the Danish version.

    Have you experienced this as well? I would assume drag ‘n drop should be an option in both versions. But this issue is the reason why I currently stick to the manuel download version.

    Best,
    Torben

  • Hi there! I must add that there are certain restricions when using Power BI Desktop from the Microsoft Store… I faced a few issues when connecting to Oracle databases, that as Microsoft mentions is this link is resolved by downloading the Download Center version of Power BI (https://docs.microsoft.com/en-us/power-bi/desktop-connect-oracle-database).
    I didn’t face any other restriction YET, but I assume this is not the only one!
    Great post by the way.

    • Hi Ignacio
      There are some connectors which behave differently in the two versions, and that is why you have been advised to download.
      Cheers
      Reza

Leave a Reply

%d bloggers like this: