Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Unexpected PowerBI export limitation

Hello community   I recently bumped into an issue, when I try to export underlaying data from a powerbi matrix to an excel file. The issue I have is, that within the powerbi matrix, I am able to se...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

HI Anonymous ,

Which connection mode your datasource is? If your datasource is in directquery mode, it can only export 16Mb records.

power bi visualization export data:limitations and considerations

When using DirectQuery, the maximum amount of data that can be exported is 16 MB. This may result in exporting less than the maximum number of rows, especially if there are many columns, data that is difficult to compress, and other factors that increase file size and decrease number of rows exported.

Regards,

Xiaoxin Sheng

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hello 

    Thank you for your respond. My datasource is a SSAS database to which I "connect live". I guess that is direct query for a tabular database.

    However, I checked the file size of the downloaded excel files. The size of one file does not exceed 5Mb. So this should not be the problem, unless of course the data record gets even further compressed when saved in excel. In that case it could be that a 16Mb record becomes a 5Mb excel file. But I highly doubt that.

    What do you think?

    Regards

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi Anonymous ,

      As documented mention, if your data model are complex or has too many fields in data tables which you try to export, they will also effect export row amount.

      Regards,

      Xiaoxin Sheng