Tenant Setting Difference between Export Data and Export to Excel

[Anonymous]

Hi , 

These two settings are very confusing. Can someone please tell the difference between these two. thanks 

[V-pazhen-msft · Accepted solution]

@Anonymous 

To make things simple: 

1. when enable Export to Excel only, users can only use the "export data“ in the more option(...) of the visuals on the report pages.

2. when enable Export to Data, users can also "Export data" on the report pages. In addition to that, users can "export to .csv" on the dashboard tiles, "Analyze in Excel" on the top right menu bar, including "Export data" on the report pages.

Paul Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mwaters4]

So... im still confused... should I apply these settings as Microsoft "appears" to want me to do on "Export to Excel" in the Power BI Admin portal or not?

I still dont really understand what this will impact.  Can you clarify?

Here is what my screen looks like: