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.