-
UPDATE Aug 16, 2013: Excel 2013 stand-alone now includes Power Pivot (now the name has a space and it is no longer a single word!). This post was originally published on Feb 18, 2013 and is now outdated. If you… Read more
-
This article describes the reasons why an Excel pivot table may be slow when using the Analyze in Excel feature of Power BI. Read more
-
A couple of weeks ago the first version of Vizubi has been released. It is an Excel AddIn with many of the features of PowerPivot, but also with a few important differences. I made some tests and in this post… Read more
-
Recently I have seen a long demo of BonaVista Dimensions. It is a product that is able to create reports and, most important dashboards. You can use it also without SQL Server and Analysis Services, just by importing data in… Read more
-
Microsoft recently released the Analyze in Excel feature, which allows you to connect an Excel pivot table to a data model published on Power BI. I think/hope that Microsoft will enhance this feature to extend its current limits. For example,… Read more
-
A little background: in these days I’m preparing sessions for some upcoming conferences in Italy (despite the English titles, most of the sessions will be in Italian: Microsoft SharePoint & Office Conference 2010 next week and Microsoft SQL Server &… Read more
-
The August 2015 update of Power BI Desktop added two important features for existing Excel and Analysis Services users: Import Excel Power BI artifacts (Data Model, Queries, Power View) into a new Power BI Desktop file Live Analysis Services Connections: Ability… Read more
-
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… Read more
-
Our new book about PowerPivot 2013 is finally available in printed edition, too! The title is Microsoft Excel 2013: Building Data Models with PowerPivot and it is a partial rewriting of the previous book about PowerPivot for Excel 2010. In… Read more
-
DAX supports dates starting in 1900 and while teaching DAX I always explain that DAX manages dates like Excel, which is the reason why these limitations exist. Actually, this is true – but answering to a comment today I realized… Read more