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.

データ型

string

デフォルト値

""

解説

When you enable UseMDX, you can use the ExtraProperties connection property to add extra values to the PropertiesList in the XMLA request. Specify these properties as name=value pairs, separated by semicolons. For example: Catalog=MyCatalog;Cube=MyCube;.

You can retrieve a list of valid property names by executing the following query:

SELECT * FROM $System.DISCOVER_PROPERTIES

This property is useful for fine-tuning MDX requests to include custom parameters required by your specific Power BI environment.