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...
Ah right, so that is a setting for the whole organization? Then this is not a solution. Hopefully Power BI soon adds the setting per report like they currently have these export options:
It's fine that they add the option but it should not be the default options since it is very confusing for users if they open an excel file with no data. Also it's not very user friendly since to make the data appear they have to click twice "enable editing" and "enable content" and then the data also does not look the same as before, since now more unnecceasry columns (like the sort by) are added.