Unexpected PowerBI export limitation

[Anonymous]

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 see the correct rows and values (as excepted), but when I export the data, I always only see data for the last 3 months.

The problem can not be explained by the actual restrictions powerbi has when using the export function (https://docs.microsoft.com/de-de/power-bi/visuals/power-bi-visualization-export-data)

I checked that several times. For example: The exported excel file does not exceed the 150'000 rows, (but interestingly always has around 90'000 rows).

I also checked with other people that there are no filters I might have missed. I have full administrative rights on the datasource. Therefore I don't understand why this happens.

Is this an issue other people have experienced as well? Can someone guess why I have this problem?

Thank you for your help.

[v-shex-msft]

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]

Hello v-shex-msft

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

[v-shex-msft]

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