How to disable analyze in Excel in Power BI

2 minute read
power bi disable analyze in excel

Home » How To » How to disable analyze in Excel in Power BI

There are many situations in which you don’t want users to download or export data from Power BI. Many people try to find this option in this tool but to no avail.

Also, the problem is pretty serious, since it’s all about protecting your data.

One user opened a thread on the official forum:

We are about to launch a Power BI Dashboard to external users and I have just realised that they will be able to use Analyse in Excel. It is not ideal that they can use Export but having external users being able to use Analyse in Excel gives them far to much access to the data and will mean that we would not be able to laucnh. Does anyone know if there is a way to turn this off?

So, the user wants to disable Analyse in Excel only for external users, but not for the internal ones, since this is a great feature to work with.

Power BI Service has this option, but it is not so obvious at first sight.

Steps to disable Analyse in Excel in Power BI

  1. Go to the Admin portal.
  2. Click on Tenant settings.
  3. Turn off Export data and Allow users to use Analyze in Excel with on-premises datasets.power bi disable analyze in excel

Although this method solves the problem, it disables a part of Power BI that the OP planned to use for internal users. So, the option is far too blunt for some people.


Check out these diagram and flowchart software for Windows 10.


Conclusion

As we said at the beginning of this article, Analyze in Excel poses a very serious problem regarding data protection. Moreover, disabling this function looks more like a workaround than a solution.

For quite a few users, it is necessary to preserve Analyze in Excel for some operations.

Nonetheless, the option to disable the feature is there. Now, Microsoft will only need to twitch it just a little bit.

Was our method helpful? Do let us know in the comment section below!

RELATED ARTICLES YOU NEED TO CHECK OUT:

Discussions

Next up

Scroll bar is missing in Chrome on Windows 10 [FIX]

Alexandru Voiculescu By: Alexandru Voiculescu
2 minute read

Google Chrome is the most popular browser out there. It is a reliable tool to surf the Internet and has many great features. However, nothing […]

Continue Reading

What to do when your Uplay achievements are not syncing

John Taylor avatar. By: John Taylor
2 minute read

Uplay is an amazing game distribution platform created by Ubisoft. It can be used to buy and download games as well as DLCs. It can […]

Continue Reading

FIX: Ubisoft server unavailable

John Taylor avatar. By: John Taylor
2 minute read

The market is filled with game distribution platforms like Steam, Epic Games Store or GOG. As such, some gaming giants have decided to build their […]

Continue Reading