Export Data

Bravo can export the data of one or more tables to multiple CSV files in the same folder or into a single Excel file with one worksheet for each table.

1. Select/unselect all
   Toggles the selection of the tables to export.
2. Select individual tables
   Select or unselect the table to export in the corresponding line.
3. Export as
   Chooses the export format:
   • Excel Spreadsheet: one worksheet for every exported table in a single Excel file. There is a limit of one million rows per worksheet. Tables with more than one million rows are highlighted with a warning icon. The CSV format can export the full content of larger tables.
   • CSV Files: one comma-separated-value file (CSV) for every exported table in a specified folder.
4. Export Summary
   Activates the Export Summary option for Excel files, which creates an additional worksheet with the summary of exported tables.
5. Total selection to export
   Displays the number of selected tables to export, alongside with their total number of rows and size.
6. Export Selected
   Exports the selected files,

The CSV export format shows different format options:

1. Search Table
   Filters the tables containing the text specified in the textbox. Selected tables are exported even though they are not listed because of a filter.
2. Total selection to export
   Displays the number of selected tables to export, alongside with their number of rows and size, regardless of their visibility in the above list.
3. Export as CSV options
   Shows the options to export CSV files:
   • Encoding: Specifies the encoding format:
     • UTF-8 is usually more compact and the preferred choice.
     • UTF-16 is available to solve compatibility issues if other programs cannot open the files exported by Bravo.
   • Fields Delimiter: Specifies the delimiter character for the CSV file. The comma (,) is the standard, but different cultures may use different delimiters:
     • Automatic: Uses the default list separator defined by the Windows settings.
     • Comma: Standard field delimiter (,).
     • Semicolon: Semicolon field delimiter (;).
     • Tab: Tab field delimiter. This choice export data in a tab-separated-value format, also known as TSV.
     • Other: Specifies a custom field delimiter.
   • Enclose Strings in Quotes: Ensures that every string is enclosed in double quotes.
   • Save in a Subfolder: Creates a subfolder with the name of the model. All the CSV files are saved in that subfolder, otherwise the files are created in the folder selected when the user clicks the Export Selected button.

The Export Data feature in Bravo does not provide filters over rows and columns. DAX Studio has more advanced features to export a selection of rows or columns: Query Builder and Export Data