THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

SQLBI - Marco Russo

Please visit the same blog at - comments are now disabled here but you can comment on the new blog (all blog posts available here are available there, too).
You can follow me on Twitter: @marcorus

Execute a #DAX Query on #SSAS #Tabular in #Excel

Apparently Excel does not offer a way to import data in Excel by using a DAX query on Analysis Services. The Data Connection Wizard seems to offers only the ability to create a PivotTable when you connect to Tabular, but not a Table (see the Table option disabled in the next picture).


However, the workaround is to create a connection file and changing it with an editor (such as Notepad) so that you can write your own DAX query (or MDX, too!) and import data in an Excel table.


You can write a step-by-step guide on the article Import Data from Tabular Model in Excel Using a DAX Query I published on SQLBI web site.

Published Thursday, January 31, 2013 2:54 PM by Marco Russo (SQLBI)
Filed under: , , ,



Chris Webb said:

January 31, 2013 10:53 AM

Marco Russo (SQLBI) said:

Chris, what do you mean? Kasper's article was about connecting to the embedded PowerPivot Data Model, not to a SSAS Tabular instance...

January 31, 2013 11:43 AM

Chris Webb said:

Sorry, ignore me - I didn't read the bit about Tabular models in the title...

January 31, 2013 12:01 PM

Marco Russo (SQLBI) said:

No problem! :)

January 31, 2013 6:19 PM
New Comments to this post are disabled

About Marco Russo (SQLBI)

Marco Russo is a consultant, writer and trainer specialized in Business Intelligence with Microsoft technologies. He runs the SQLBI.COM website, which is dedicated to distribute resources useful for BI developers, like Integration Services components, Analysis Services models, tools, technical information and so on. Marco is certified as MCT, MCDBA, MCSD.NET, MCSA, MCSE+I.

This Blog



Privacy Statement