560 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owls only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
Search our website
We also send out useful tips in a monthly email newsletter ...
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.
This blog is part of our online SSAS Tabular tutorial; we also offer lots of other Analysis Services training resources. |
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!
Parts of this blog |
---|
|
Some other pages relevant to the above blogs include:
Kingsmoor House
Railway Street
GLOSSOP
SK13 2AA
Landmark Offices
99 Bishopsgate
LONDON
EC2M 3XD
Holiday Inn
25 Aytoun Street
MANCHESTER
M1 3AE
© Wise Owl Business Solutions Ltd 2023. All Rights Reserved.