cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Sokon Member
Member

Re: Disable Analyse in Excel

This is a information security issue as well!

 

Think about a huge dataset that potentially covers a lot of use cases and that is used for a report that only uses a small part of that big model. Sharing this single report will expose all data to be analyzed and loaded into Excel. That's not only an issue for external users but vor internals as well because it circumvents permissions a report creator might have in mind when explicitely not including a field into his/her report!

 

As a report creator we need to explicitly allow this feature to be availlable to the consumers for each report individually! To support the according idea, please vote for it here:

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/34107790-publish-to-app-restrict-...

Highlighted
Barendnu Frequent Visitor
Frequent Visitor

Re: Disable Analyse in Excel

We seem to have found a workaround for this:

 

  1. In Power BI Desktop, click data on the left:
    1Data.png
  2. In the bar on the right-hand side of the data screen, for each table, select hide in report view:
    2Hide.png
  3. Click report on the left to return to the report view:
    3Report.png
  4. Optionally, in the bar on the right-hand side in report view, you can choose to view hidden tables (this will not affect the online report, only while working in PowerBI Desktop):
    4ViewHidden.png
  5. Publish this version.

 

 

 

Now, users in our workspace can still export summarized Excel Data (as we want):

ExportExcel.PNG

 

But they cannot view/export the underlying data - nor via the Excel download option shown above, nor via the "Analyse in Excel" link topright. The "Analyse in Excel" link is still there, but only opens an empty Excel file:

5Analyse.PNG

 

 

(EDIT: now I see that todo-claro already mentioned this same workaround already on the previous page. Thnx todo-claro Smiley Happy)

 

Still, I hope Microsoft will simply add a "turn Analyze in Excel on/off" button, while keeping the functionality to export summarized data to Excel.

Sokon Member
Member

Re: Disable Analyse in Excel

@Barendnu: Thanks for your reply! Yes, I know about hiding fields and it might help in certain scenarios.

However, that approach cripples the use of "Power BI Live Connect" as well!

We make extensive use of that feature and build big datasets that are used multiple times in reports. While you must be member of the workspace to access the dataset with live query, Analyze in Excel offers the same capabilities when the report is simply shared.