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

SQLBI is a blog dedicated to building Business Intelligence solutions with SQL Server.
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: , , ,

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



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

Leave a Comment


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