January 2013 - Posts

• 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 Read More... Posted Thursday, January 31, 2013 2:54 PM by Marco Russo (SQLBI) | 4 Comments Filed under: SSAS, Excel, DAX, Tabular

• Linked Table, Reverse Linked Table and Linkback Table in Excel 2013 #powerpivot

  Kasper de Jonge wrote a blog post last year introducing an interesting new feature in Excel 2013: you can write a DAX query that extracts data from the PowerPivot model and returns a table in Excel. Such a table can be used as a Linked table for the same Read More... Posted Monday, January 21, 2013 3:35 PM by Marco Russo (SQLBI) | 0 Comments Filed under: Excel, PowerPivot

• PowerPivot Compatibility across versions

  There are several versions of PowerPivot available and starting with Excel 2013 there are also several versions of Excel. It is useful to look at the compatibility between the different versions of Excel and PowerPivot available now. As a general rule Read More... Posted Monday, January 14, 2013 2:44 PM by Marco Russo (SQLBI) | 8 Comments Filed under: Excel, SQL Server 2008, PowerPivot, SQL Server 2012