Disable Analyze in excel at dataset or report level

[Anonymous]

Hi,

Although we are able to disable Analyze in excel at tenat level, it does not help. Beacause sometimes it useful to have it available for certain workspaces/reports/dataset over others.

Is it possible to allows owners of the workspace to turn off analyze in excel at Dataset or Report level?

Kind regards,

Abs

[v-eqin-msft]

Hi @Anonymous ,

Sorry to disturb you...

But did I answer your question ? Please mark my reply as solution. Thank you very much.

Best Regards,
Eyelyn Qin

[Anonymous]

@v-eqin-msft sorry about that, it is hard to find users to be able to test, due to lockdown. It is working I just tested it. thank you so much!

[v-eqin-msft · Accepted solution]

Hi @Anonymous ,

You could assign the users as Viewer role, then they could not use Analyze in Excel feature neither on Dataset level nor Report level.

Did I answer your question? Please Mark my post as a solution. Thank you.

Best Regards,
Eyelyn Qin

[collinq]

HI @Anonymous ,

I don't have time to test it right now, but I believe that if you turn it off for an individual report, you do so by going to the setting and selecting "None" for the Export Data type.

I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!

[Anonymous]

Hi @collinq 

I am afraid, that is a solution for completely different issue. Here the concern is that with Analyze in excel enabled by default for all reports - it allows users to see the whole underlying dataset, which defeats the purpose, when we just want users to only be able to export what they can see on the report.