Forum Discussion
Anonymous
3 years agoNot applicable
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...
d4t0r
3 years agoRegular Visitor
Hi Martine2607,
did you find a way to get rid of 500k option ?
BR
dbexpress108
2 years agoRegular Visitor
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 connection
Disabled for the entire organization
Users 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.