Forum Discussion

Icon for Continued Contributor rank

Continued Contributor

4 years ago

Export Data new default can't be changed

We used to get two options: Summarized data and underlying data. Now we have three options Data with current layout Summarized Data Underlying data The default is Data with current lay...

Icon for Community Support rank

Community Support

4 years ago

Improvements to the Export to Excel experience for Power BI table and matrix visuals is still in preview.

You can leave your comment in the comment section of this official blog.

Export to Excel Improvements for Table and Matrix Visuals (Preview)

If you have any other suggestions on improvements for Power BI and Excel, please submit an idea.

Best Regards,
Community Support Team _ Eason

bsheffer
Continued Contributor
4 years ago
If it is in preview is there a place on the service where I can turn it off?
- v-easonf-msft
  Community Support
  4 years ago
  Hi, bsheffer
  
  Sorry, no such option is provided in the report settings on either Desktop or Service.
  
  At present, if the export of summary data is enabled, the export of the current layout data will be enabled by default, which is a bit similar to that when the export of the underlying data is enabled, the export of summary data will be enabled by default.
  
  Best Regards,
  Community Support Team _ Eason
  - abpgupta
    Continued Contributor
    4 years ago
    Hi v-easonf-msft ,
    
    This option is somehow changing order of fields and also including fields used in conditional formatting. Since this is default option, it's confusing to users. Is there any way to provide option to default to "Summarize data" view for Tables and May be Matrix export can be defaulted to new view. Thanks!