|When Importing from Tabular Model use DAX|
|Written by Kasper de Jonge|
|Thursday, 25 April 2013 21:52|
I recently was building a model in Excel that was using data from a Tabular Model. I started going down the import path by selecting import from Analysis Services in the PowerPivot window and use the MDX query designer to select the data that I want to import into PowerPivot / Excel Model.
I imported the data but it took over one hour to import the data. I was very unsatisfied with the time it took me to refresh the data. Then I got thinking, MDX is not really designed for these tabular result sets, DAX is. As this is a tabular model I can use DAX to get the results. Unfortunately I don't have a automated DAX query editor but writing the DAX equivalent of this particular MDX query is quite simple. After rewriting the query to DAX is brought back the import time to .. 3 minutes. From one hour on the same dataset.Read more...
Latest Author Articles
- Export a table or DAX query from Power Pivot to CSV using VBA
- Excel 2013, Power Pivot and Power View on any device with Azure RemoteApp
- Where your calculated field is executed matters
- Show the sum of sales for the last 3 days based on date selection
- Show the goals when your team is either away or home