Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

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

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
v-danhe-msft
Microsoft Employee
Microsoft Employee

Hi @Anonymous,

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.
Anonymous
Not applicable

@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!

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


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG
Anonymous
Not applicable

@Seth_C_Bauer

 

Publishing them as an App on a premium capacity.

Anonymous
Not applicable

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

@Anonymous 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?

 

 


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG
Anonymous
Not applicable

@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.

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]

Seth_C_Bauer
Community Champion
Community Champion

@Anonymous 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?


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG
Anonymous
Not applicable

@Seth_C_Bauer

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

Helpful resources

Announcements
September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Top Solution Authors