XLSX command
This command will output an Excel xlsx file based on the results of a DAX query
Syntax
DSCMD XLSX <OutputFile> [OPTIONS]
Arguments
| Name | Description |
|---|---|
| <OutputFile> | The path and name of the file to which the XLSX data will be written |
Options
| Option | Description |
|---|---|
| -h, --help | displays the help for the XLSX command |
| -s, --server <SERVER> | the name of the server to connect to |
| -d, --database <DATABASE> | The name of the tabular database to export from |
| -u, --userid <USERID> | The username to use for authentication (see Authentication for more details) |
| -p, --password <PASSWORD> | The password to use for authentication (see Authentication for more details) |
| -c, --connectionstring <CONNECTIONSTRING> | The connection string for the data source |
| -f, --file <FILE> | A file containing a DAX query to be executed. Could be a text file or .dax or .daxx |
| -q, --query <QUERY> | A string with the DAX query to be executed |
| -m, --parameter <PARAMETER=VALUE> | Parameter values to be passed into the query (see -m --parameter option below) |
-m --parameter Option
If you have a DAX query with parameters you can pass these in using the -m, -parameter option, if you have multiple parameters in your query you can provide multiple parameter values
In the following example the query has 2 parameters @myColor and @myCategory which are passed in using 2 -m options
eg.
dscmd xlsx c:\temp\myquery.xlsx -s localhost\tab19 -d "Adventure Works DW" ^
-m myColor=Red ^
-m myCategory=Bikes ^
-q "EVALUATE FILTER('product', 'product[Color]=@myColor && 'product'[Category]=@myCategory)"
Examples
The following example exports to a file called myquery.xlsx in the c:\temp folder and connects as the user running the command
dscmd xlsx c:\temp\myquery.xlsx -s localhost\tab19 -d "Adventure Works DW" -q "EVALUATE 'product'"
dscmd xlsx c:\temp\myquery.xlsx -c "Data Source=localhost\tab19;initial catalog=Adventure Works DW" -q "EVALUATE 'product'"