cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MrSisense Regular Visitor
Regular Visitor

Cant turn off Analyze in Excel

In a report, when selecting the option "Do not allow export of data", it will still be possible to use the option "Analyze in Excel" and get access to the underlying data. Is this a bug or intentionally done?

1 ACCEPTED SOLUTION

Accepted Solutions
Barendnu Frequent Visitor
Frequent Visitor

Re: Cant turn off Analyze in Excel

I completely agree with MrSisense here.

 

We want some workspace users to view our report, download summerized Excel data, but not view/download the underlying data (of course also not via "Analyze in Excel"). This seems not to be possible currently.

 

[EDIT: A workaround has been posted here]

View solution in original post

10 REPLIES 10
Super User
Super User

Re: Cant turn off Analyze in Excel

@MrSisense There is another setting specific to "Analyze in Excel" in the tenant settings under "Integration Settings" have you disabled the "Use Analyze in Excel with on-premises datasets" capability?


Near SE WI? Join our PUG Milwaukee Brew City PUG
v-danhe-msft Super Contributor
Super Contributor

Re: Cant turn off Analyze in Excel

Hi @MrSisense,

As Seth_C_Bauer said, you could check below options in Admin portal in Power BI service:

1.PNG2.PNG

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
MrSisense Regular Visitor
Regular Visitor

Re: Cant turn off Analyze in Excel

@Seth_C_Bauer

Disabling this does not actually disable it if the export setting is turned off.

MrSisense Regular Visitor
Regular Visitor

Re: Cant turn off Analyze in Excel

@v-danhe-msft

Disabling this option does disable all the exports, however this is not what one would want as you want to be able to select export setting on a report basis. In a PowerBI report there's an option to choose if users are able to export underlying + summarized, summarized only or nothing at all, however these options do nothing if the export function is enabled since the analyze in excel option is always available, even when it is turned off!

Super User
Super User

Re: Cant turn off Analyze in Excel

@MrSisense Are you sharing reports, or granting access to the workspace to end users?


Near SE WI? Join our PUG Milwaukee Brew City PUG
MrSisense Regular Visitor
Regular Visitor

Re: Cant turn off Analyze in Excel

@Seth_C_Bauer

 

Publishing them as an App on a premium capacity.

MrSisense Regular Visitor
Regular Visitor

Re: Cant turn off Analyze in Excel

Anyone? Seems like a pretty big problem, certainly from a security perspective.

Highlighted
Super User
Super User

Re: Cant turn off Analyze in Excel

@MrSisense Ok, couple things here. I'm a bit confused because we are talking about two different controls, and the behaviour you describe keeps jumping between the two features.

Specifically for Analyze in Excel I rechecked the documentation -> https://docs.microsoft.com/en-us/power-bi/service-analyze-in-excel

There are a couple big callouts:

1) "Administrators for Power BI tenants can use the Power BI Admin Portal to disable the use of Analyze in Excel with on-premises datasets housed in Analysis Services (AS) databases. When that option is disabled, Analyze in Excel is disabled for AS databases, but continues to be available for use with other datasets."

 

For Analyze in Excel, apparently it won't disable unless your using SSAS as a data source

 

2) "It's important to know that using Analyze in Excel exposes all detail-level data to any users with permission to the dataset."

Now, what I haven't tested, is whether or not "permission" is shared, or edit/read on the workspace.

 

A couple recommendations:

Check to see if you have the same behavior if you only share the report itself, not the app.

Ensure the user is not part of the app workspace.

 

What is the intent here? You keep mentioning security, so you only want end users to be able to see the reports and not export at all in any way?

 

 


Near SE WI? Join our PUG Milwaukee Brew City PUG
MrSisense Regular Visitor
Regular Visitor

Re: Cant turn off Analyze in Excel

@Seth_C_Bauer

 

Not being able to turn off "Analyze in Excel" makes the option in the report to only allow "Summarized" export useless. The usecase is exactly that, we want the users to export the summarized data in tables, but not all the underlying data.

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 47 members 973 guests
Please welcome our newest community members: