http://www2.sqlblog.com/blogs/marco_russo/archive/2013/01/31/execute-a-dax-query-on-ssas-tabular-in-excel.aspxApparently 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 optionenCommunityServer 2.1 SP2 (Build: 61129.1)http://www2.sqlblog.com/blogs/marco_russo/archive/2013/01/31/execute-a-dax-query-on-ssas-tabular-in-excel.aspx#47413Thu, 31 Jan 2013 15:53:15 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:47413Chris Webb<p>Umm, if you're in Excel 2013 there's a better way. See: <a rel="nofollow" target="_new" href="http://www.powerpivotblog.nl/implementing-histograms-in-excel-2013-using-dax-query-tables-and-powerpivot">http://www.powerpivotblog.nl/implementing-histograms-in-excel-2013-using-dax-query-tables-and-powerpivot</a></p> http://www2.sqlblog.com/blogs/marco_russo/archive/2013/01/31/execute-a-dax-query-on-ssas-tabular-in-excel.aspx#47416Thu, 31 Jan 2013 16:43:57 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:47416Marco Russo (SQLBI)<p>Chris, what do you mean? Kasper's article was about connecting to the embedded PowerPivot Data Model, not to a SSAS Tabular instance...</p> http://www2.sqlblog.com/blogs/marco_russo/archive/2013/01/31/execute-a-dax-query-on-ssas-tabular-in-excel.aspx#47418Thu, 31 Jan 2013 17:01:56 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:47418Chris Webb<p>Sorry, ignore me - I didn't read the bit about Tabular models in the title...</p> http://www2.sqlblog.com/blogs/marco_russo/archive/2013/01/31/execute-a-dax-query-on-ssas-tabular-in-excel.aspx#47430Thu, 31 Jan 2013 23:19:57 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:47430Marco Russo (SQLBI)<p>No problem! :)</p>