Export Properties: Microsoft Power BI

The table below describes the properties that can be specified for exports to Microsoft Power BI.

Properties	Description
Table	The name of the selected table to be exported.
Export Type	The file type to which your export will be saved.
Table Name	This setting specifies the table name data will be exported to. Enter the name of the table to which data will be exported. You can embed macros (of the form &[macro]) in the table name. In creating a table name, the following rules apply: Table names must be between 1 and 100 characters. They must not start or end with whitespace characters. They cannot contain any of the following: ! \ " $ % & ' ( ) * + , . / Note that issues in compliance with these rules will prevent you from performing the export. Hover your mouse over the Table Name field to display the rules to consider in creating your table name.
Filter	This setting specifies which filter, if any exist, to apply to the table when it is exported. When All Filters is selected as a filter option, exports will automatically be named according to the file name.
Sort	This setting specifies what sort to apply to the table when it is exported.
When Table Exists	This setting specifies what Data Prep Studio should do if a table or sheet with the same name you specified already exists. The options are as follows: Overwrite Skip
Export All Rows/Limited Rows	For tables with defined row limits, this setting specifies whether the defined row limits should be respected during export. Select the appropriate checkbox to instruct Data Prep Studio to export all rows or only those rows that fall within the limit you have set.

Intellectual Property Rights Notice | Technical Support