I want end users to be able to export to excel, but not analyse in excel

[ThomasWeppler]

I want my end users to be able to export in excel, but not analyse in excel.

 

If I disable this option in the admin portal will people still be able to export to excel or will the lose both the export and analyse option?

[v-yalanwu-msft]

Hi, @ThomasWeppler ;

I tested it , If I disable this option in the admin portal will people still be able to  analyze in excel.

Best Regards,
Community Support Team_ Yalan Wu

[v-yalanwu-msft]

Hi, @ThomasWeppler ;

You just need to disable this option "Allow live connections"

result:

refer:

https://docs.microsoft.com/en-us/power-bi/admin/service-admin-portal#allow-live-connections

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[DavisBI · Accepted solution]

@ThomasWeppler Hi, In this case both 'export to excel' and 'analyze in excel' will be disable