How to get data from tabular models using DAX queries in various programs
Part one of a six-part series of blogs

Knowing how to write DAX queries is one thing, but where are you going to use them? This blog shows how you can integrate DAX queries into SSMS, SSRS, SSIS, Excel and PowerPivot.

  1. Using DAX queries in SQL Server and other applications (this blog)
  2. Running DAX queries within Management Studio
  3. Basing SSRS (Reporting Services) reports on DAX queries
  4. Writing DAX queries in Integration Services (SSIS)
  5. Retrieving data into Excel using DAX queries
  6. Loading data into PowerPivot data models using DAX queries

This blog is part of our online SSAS Tabular tutorial; we also offer lots of other Analysis Services training resources.

Posted by Andy Brown on 18 February 2016

You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

Using DAX queries in SQL Server and other applications

A previous blog explains how to write DAX queries.  This one shows how you can use DAX queries in the following applications:

Application Notes
SSMS A refresher on how to run DAX queries within SQL Server Management Studio.
SSRS How to create data sources in Reporting Services based on the output from DAX queries.
SSIS Creating a source to import data from a DAX query in SQL Server Integration Services.
Excel Running DAX queries in Excel to import data from tabular models.
PowerPivot Importing data into a PowerPivot data model using DAX queries.

Let's start with the first of these, and work our way down the list! 

This blog has 0 threads Add post