cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MariaFlorenciaB Regular Visitor
Regular Visitor

Disable Analyze in Excel

Hi everyone!

 

I have a question, is there any possiblility to disable the "Analyze in Excel" that POwer BI online offers? 

Thanks!!

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-yuezhe-msft
Moderator

Re: Disable Analyze in Excel

Hi @MariaFlorenciaB,

You would need to turn off “Allow users to use Analyze in Excel with on-premises datasets" setting in Power BI Admin portal, and you also need to turn off “Export data” setting at the same time.
1.PNG

There is also a discussion about disabling Analyze in Excel in the following thread.
https://community.powerbi.com/t5/Service/Disable-Analyse-in-Excel/td-p/74106

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 REPLIES 5
Moderator v-yuezhe-msft
Moderator

Re: Disable Analyze in Excel

Hi @MariaFlorenciaB,

You would need to turn off “Allow users to use Analyze in Excel with on-premises datasets" setting in Power BI Admin portal, and you also need to turn off “Export data” setting at the same time.
1.PNG

There is also a discussion about disabling Analyze in Excel in the following thread.
https://community.powerbi.com/t5/Service/Disable-Analyse-in-Excel/td-p/74106

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
MariaFlorenciaB Regular Visitor
Regular Visitor

Re: Disable Analyze in Excel

Thanks @v-yuezhe-msft ! Last question, this configuration works when you have the PRO version of Power BI? Cause I cant find it in the FREE version.

 

Thank you again!!

Moderator v-yuezhe-msft
Moderator

Re: Disable Analyze in Excel

Hi @MariaFlorenciaB,

Yes. And please note that your account needs to be marked as a Global Admin, within Office 365 or Azure Active Directory, to get access to the Power BI admin portal.

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
apfenech Frequent Visitor
Frequent Visitor

Re: Disable Analyze in Excel

Is there a way to turn off the Analyze in Excel feature only and allow the Export Data function?

chaz2jerry Regular Visitor
Regular Visitor

Re: Disable Analyze in Excel

Unfortunately this is not available I don't think.  There is an idea posted for this feature, pls vote it up if you are interested.

 

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/20487199-disable-analyze-in-excel...