Miscellaneous
This section provides a complete list of the Miscellaneous properties you can configure in the connection string for this provider.
| Property | Description |
| CustomHeaders | Specifies additional HTTP headers to append to the request headers created from other properties, such as ContentType and From. Use this property to customize requests for specialized or nonstandard APIs. |
| ExposeMemberKeys | Enable this property to convert each level into a measure, which is a numeric value that supports calculations like summing, averaging, and other aggregations. By default, levels remain as String types, so they do not support direct calculations. |
| ExpressionInDescription | Enable this property to append measure expressions in the descriptions of measure columns. By default, the provider includes only remarks in measure column descriptions. |
| ExtraProperties | Specifies additional properties to include in each MDX request sent to Microsoft Power BI XMLA. Use this property to customize the PropertiesList of the XMLA request when UseMDX is enabled. |
| MaxRows | Specifies the maximum number of rows returned for queries that do not include either aggregation or GROUP BY. |
| Other | Specifies additional hidden properties for specific use cases., to be used only when our Support team advises it, to address specific issues. See Remarks for details. |
| ResponseRowLimit | Specifies the maximum number of response rows allowed before triggering an error. Use 0 to remove the limit entirely. This property helps prevent performance issues caused by large queries. |
| ShowHiddenEntities | Enable this property to include hidden dimensions, measures, and levels in query results. By default, the provider excludes entities marked as hidden. |
| SplitMeasures | Enable this property to split the Measures table into individual tables and distribute measures into their respective dimension tables. |
| SplitMeasuresOn | Specifies the priority for organizing measures into tables when SplitMeasures is enabled. Provide a comma-delimited list of attributes to determine the sorting order. |
| Timeout | Specifies the maximum time, in seconds, that the provider waits for a server response before throwing a timeout error. |
| UseMDX | Enable this property to pass MDX queries directly to Microsoft Power BI XMLA. When disabled, the provider translates SQL-92 queries into operations on the modeled views. |
| UserDefinedViews | Specifies a filepath to a JSON configuration file that defines custom views. The provider automatically detects and uses the views specified in this file. |
| Workspace | Specifies the Premium Power BI workspace(s) to connect to, using a comma-separated list of workspace names. |