Remove excel export with live connection format

Question

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 connection. However then when you open the file you do not see any data untill you "enable editing" and "enable content" . Is it possible to turn of the live connection? Or make the default option Excel without live connection?&nbsp;Thanks!

anonymous · Answer

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.&nbsp;

anonymous · Answer

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?

ibarrau · Answer

You can find it on the top right corner. There is a settings option-&gt; admin portal -&gt; tenant settings. Only PowerBi Admins role can see this options.
You can read more about it here:&nbsp;https://learn.microsoft.com/en-us/power-bi/admin/service-admin-portal
I hope that helps,

ibarrau · Answer

Hi. That's a new option that has been released to get more rows. If you want to export the way it was before just open de dropdownlist and change it

&nbsp;
For now the default option shown is the live connection. I don't think you can change it, but you can try removing the options of analyze excel or excel live connection from the tenant settings and check if that removes it.
I hope that helps,

d4t0r · Answer

Hi&nbsp;Martine2607,&nbsp;did you find a way to get rid of 500k option ?&nbsp;&nbsp;BR

Forum Discussion

Related content

Export table with live connection

remove duplicate value within a row

EXPORTING

Removing Duplicates

Remove trailing commas