Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Do not limit Matrix visualization "Export data" columns

Submitted by Anonymous on ‎02-25-2022 07:40 AM

We are using Matrix visualization in one of our reports.

The data is presented in 1320 rows. The columns count can vary - from 10 up to 100 columns, depending on the user filters.

 

In some cases we need to export 1320 rows x 100 columns data set into an Excel data file(Note: We're not using pivot tables, just plain xlsx file with data populated.). However the data output is trimmed to the first 61 columns.

 

Expected result: "Export data" button should produce a file which contains all data visible in the report.

Status: Investigating

What is your data source in this report and the connection mode is import or direct query?

 

To export data to .xlsx file, the limitation of import mode is 150,000 rows.

 

When using DirectQuery, the maximum amount of data that Power BI can export is 16-MB uncompressed data. An unintended result may be that you export less than the maximum number of rows of 150,000. This is likely if:

  • There are too many columns. Try reducing the number of columns and exporting again.

  • There's data that is difficult to compress.

  • Other factors are at play that increase file size and decrease the number of rows Power BI can export.

See: Considerations and limitations 

 

Best Regards,
Community Support Team _ Yingjie Li

See more ideas labeled with:
1 Comment (1 New)
Comments
v-yingjl
Community Support
Community Support
‎02-27-2022 09:48 PM
Status changed to: Investigating

What is your data source in this report and the connection mode is import or direct query?

 

To export data to .xlsx file, the limitation of import mode is 150,000 rows.

 

When using DirectQuery, the maximum amount of data that Power BI can export is 16-MB uncompressed data. An unintended result may be that you export less than the maximum number of rows of 150,000. This is likely if:

  • There are too many columns. Try reducing the number of columns and exporting again.

  • There's data that is difficult to compress.

  • Other factors are at play that increase file size and decrease the number of rows Power BI can export.

See: Considerations and limitations 

 

Best Regards,
Community Support Team _ Yingjie Li

Idea Statuses