Forum Discussion
Remove excel export with live connection format
Since recently (today?) the export options have changed for the reports on power bi service. Currently when a user exports the data from a chart the default file format is set to Excel with live conn...
Thanks a lot for your quick reply! Where can I find the tenant settings to remove the analyze in excel or excel live connection options?
You can find it on the top right corner. There is a settings option-> admin portal -> tenant settings. Only PowerBi Admins role can see this options.
You can read more about it here: https://learn.microsoft.com/en-us/power-bi/admin/service-admin-portal
I hope that helps,
Hi Martine2607,
did you find a way to get rid of 500k option ?BR
Hi d4t0r,
I had this exact issue and managed to turn off the Excel live connection by turning off the following option in tenant settings:
Users can work with semantic models in Excel using a live connectionDisabled for the entire organizationUsers can export data to Excel from a report visual or semantic model, or export a semantic model to an Excel workbook with Analyze in Excel, both options with a live connection to the XMLA endpoint.
