Fine Tuning Data Access

The following are properties that allow for more granular control over data access:

• UseMDX: Indicates if MDX queries are being submitted. By default this is false, which will cause the driver to accept only SQL-92 compliant queries.

  Setting this property to true will cause all queries to be passed through directly to Power BI XMLA.

• ExtraProperties: Additional properties to submit along with an MDX query. Only meaningful if UseMDX is true.
• IncludeJoinColumns: Boolean indicating if extra columns used to make ON conditions with joins should be added.

  These do not come back with any values - they are added purely to enable tools that require them in order to automatically set up relationships between tables when creating joins.

• ResponseRowLimit: Sets a calculated limit on the number of rows to allow the user to select before returning an error.

  Because queries are being translated to MDX, selecting only a few columns may exponentially multiply the number of expected results.

  For this reason, ResponseRowLimit is available to try and give some guidance on what types of queries are likely to result in a Timeout. May be disabled by setting to 0.