Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Duncan Paul]

Hello,

I’ve recently discovered the “Analyze in Excel” feature that is seen when viewing reportsin online powerbi. It is seen when clicking on the 3 dots on the upper right hand portion of the screen. This concerns me because it gives my users a way to examine all of the underlying data from my database, which is much more than I’ve included in the report.  Is there a way to disable my users from having this feature.  I want to share a specific report with a colleague and have them only be able to interact with that specific report. I do not want them to be able to “Analyze in Excel” and see more of the data that they’re not intended to see.

Thanks in advance.

——————————
Duncan Paul
Alltech Inc.

——————————

[Brian Petersen]

Hi Duncan,

It looks like you can manage this at a global level in the Power BI admin settings. I found the proposed solution in the thread here:

Disable Analyse in Excel

Powerbi		remove preview
Disable Analyse in Excel 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… View this on Powerbi >

Hope it helps!

——————————
Brian Petersen
VP of Customer Engagement
Jet Reports
Portland OR
5036083664
——————————
——————————————-

[Erik Svensen]

?Hi

The admin portal can be used to limit the access the Analyze in Excel feature in the Power BI Service.

Compared to the other thread it has (as so many other things in Power BI) been improved so you can specify groups etc.

——————————
Erik Svensen
PUG Leader
Denmark
es@catmansolution.com
——————————
——————————————-

[Duncan Paul]

Thank you for the response!  I have one follow up question.  Is there a way to do this without a premium subscription?  Myself and my colleagues operate on pro memberships and do not have access to the admin portal.

——————————
Duncan Paul
Alltech Inc.

——————————
——————————————-

[Domantas Gintauskas]

Isn’t Admin portal related more with Office 365 and it’s Admin than the type of Premium/Pro/Free account in Power BI? At least some time ago I saw in updates that Office 365 admin no longer has to be the same as Power BI. So if in your case these two were not separated, then I would guess O365 Admin should also be able to act as Power Bi admin.

——————————
Domantas Gintauskas
R&D Data Analyst
GN Resound
52829987
——————————
——————————————-

[Duncan Paul]

Since I didn’t have access, I was able to find an administrator within my organization that had access to the tenant settings, and was able to turn off the ‘Analyze in Excel’ tool.  Although he has turned off the tool, I’m still seeing this option in my shared reports.  I read one thread that claimed that I must also disable the ‘export data’ tool.  Is this true?  I would like to keep this tool since it only exports the data from visuals, and not the underlying data. 

To summarize: I would like to disable the ‘Analyze in Excel’ tool, yet keep the ‘export data’ tool.

——————————
Duncan Paul
Alltech Inc.
Nicholasville KY

——————————
——————————————-

[Jochen Jülke]

?interesting finding…please keep us updated of your final result. In my understanding “allow Analyse in excel” and “export data” are two different settings a Power Bi admin can configure via tenant settings, there should be no dependency between this configurations

——————————
Jochen Jülke
Team Lead / Consultant
Pmone
——————————
——————————————-

[Duncan Paul]

Our Admin was able to turn off ‘Export Data’ along with ‘Analyze in Excel’ and now when I go through I no longer have access to either tool. I’ve seen in other threads that other people are having this problem as well, so hopefully Microsoft is currently working on it.

——————————
Duncan Paul
Alltech Inc.
Nicholasville KY

——————————
——————————————-

[Duncan Paul]

If anyone is curious, here is an update to my situation:

I had our administrator disable both ‘Analyze in Excel’ and ‘Export data’ and this took away both options.  If you remember from before, we disabled ‘Analyze in Excel’ but this did not work, and we could still use this tool within the service.  Although we couldn’t find a way to keep ‘Export data’ without keeping ‘Analyze in Excel’, we found a better way to limit our users through RLS.   Although our issue is solved, I am curious as to why both of these separate tools seem to be dependent upon each other, and welcome any insights as to what could be causing this. 

Thanks PUG!

——————————
Duncan Paul
Alltech Inc.
Nicholasville KY

——————————
——————————————-

[Bertrand d’Arbonneau]

I wish this option could be turned on/off for each dataset, not just globally. If you agree you can vote for this idea here.

——————————
Bertrand d’Arbonneau
——————————
——————————————-

[Gilbert Quevauvilliers]

From my understanding you have to have both options disabled to stop the Analyze in Excel.

What I find interesting is that if you have to export the data from a visual this will export all the data supported by the underlying visual, which is just a piece of the entire dataset. Whilst using the Analyze in Excel does show the entire dataset that is published to the Power BI Service, it will not show any columns that are hidden.

And in my opinion the visuals in the Power BI reports are representative of the underlying data, so even though the users might be able to see it in a pivot table, it is just a different format, but it is still the same underlying data.

——————————
Gilbert Quevauvilliers
Power BI & Data Analytics Colnsultant
FourMoo
——————————
——————————————-