Skip to main content
Open Data Intelligence → Query Analysis, or enter Query lab from a model workspace. The page loads semantic models visible to the current workspace. Create and authorize a model first if none is available.

Query steps

  1. Select a model from the model list.
  2. Choose the query language: SQL for relational models or MDX for XMLA models.
  3. Click Template and replace names with values from the data source browser or current structure information.
  4. Click Run, or press Ctrl/⌘+Enter in the query editor.
  5. Check the row count, data source identifier, columns, and data in the result area. If it fails, read the error and correct the name or binding in the model structure.
SQL example:
MDX example:

Query limits

The query service accepts one read-only statement. SQL runs through the data source connection service, and XMLA MDX runs through the XMLA connection service. Do not use SQL on an XMLA model or SQL table syntax in MDX.

Results and recent runs

The right side of the workspace shows the latest ten runs for the current session, including model, language, statement, success or failure, duration, and row count. Refreshing the page clears this session list. The system still records query runs for operational review.

Common failures

See Query troubleshooting and run records for more help.