Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Only allow export for Summarized Data (not current or underlying data)

Hi All, 

 

I'm wondering if anyone knows how to only allow end users to download the "Summarized Data". 

 

Here I have "Underlying Data" Greyed out properly, but "Current Layout" is still an option. 

 

In PBI Services, there is no option to just include summarized data. 

 

In PBI Desktop Options, there is no mention of the 'Current Layout" Under Export options.  

 

 

Thank you!

 

Need Help

5 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    4 years ago

    Anonymous No option that I am aware of. You could post to Ideas. I believe the thinking is that if you are willing to show people the data then you wouldn't generally not want them to be able to download it. Curious as to the use case.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Thanks Greg_Deckler 

       

      The use case is end users filter their data and download an Excel sheet. 

       

      • From there, they need to be able to possibly enter different values in the "Factor" and "Min Qty" columns below. 
        • I put the Excel formulas as strings in the last three columns below, so that when they download the data, the formulas would change the values based on their changed variables. 
        • The "Current Layout" option has the downloaded dataset starting on row 1, while the "Summarized" Has the users slicers up top, so the dataset starts on row 3, which would effect which rows I put in for the formula strings. I don't want users to accidentally download the export which would change which rows are being referenced. 

       

       

    • RickySchechter's avatar
      RickySchechter
      Frequent Visitor
      2 years ago

      My use case would be to only allow users to export using "current layout" and not the "summarized data". I believe there is not an option for that at this time, please confirm. Thanks!

  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    Community Support
    4 years ago

    Hi Anonymous ,

    Sorry, no such option is provided in the report settings on either Desktop or Service.

     

    At present, if the export of summary data is enabled, the export of the current layout data will be enabled by default, which is a bit similar to that when the export of the underlying data is enabled, the export of summary data will be enabled by default.

     

    If you have any other suggestions on improvements for Power BI and Excel, please submit an idea.

     

    Best Regards,
    Community Support Team _ kalyj

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    My use case is to export all data under the summarized option only. However, in my report, I am showing the top N option.