K D on 09 Mar 2021 16:58:27
Currently only csv export is allowed with a 30,000 row limit within the PBI desktop. Whenever I have to export a file with more than 30,000 rows I have to publish to the PBI server and export to excel with a 150,000 row limit (sometimes still not enough) or split my report into multiple segments to get the whole report. This adds extra steps, time, and leaves room for error when splicing the report back together.
Best solution would be to extend the row limits on exports especially within PBI Desktop where there isn't even the export to Excel option with the 150,000 row limit.