Maintain the Sort order when exporting to CSV

[saurabhabh]

Describe the problem

When exporting to csv the data is not sorted according to the source table.

Bravo version

1.0.1

Tabular model

Power BI Desktop, import mode

Power BI

Version: 2.110.1161.0 64-bit (October, 2022)

Steps to reproduce the behavior

1 - Open the Power BI file
2 - Go to External tab and open the BRAVO
3 - click on export data
4 - Export data as CSV

The data that is exported is not sorted as per the source table.

Additional context

Trying to export more than 10 lakh rows hence have to use the export to csv.

Screenshots

No response

Anything else ?

No response

[albertospelta]

Hi @saurabhabh, Bravo does not include any sorting clause (ORDER BY) in the DAX query used for data extraction - the DAX statement executed is a simple EVALUATE <table>. If an ORDER BY clause is not specified, the sort order of the result is undefined and cannot be trusted - this is the default behaviour of the DAX query engine.

Trying to export more than 10 lakh rows hence have to use the export to csv.

Would it be possible for you to use XLSX export as an alternative option? The XLSX export has a limit of 1 million rows per table.