Some time ago, I wrote a post about how to handle Parent/Child hierarchies in PowerPivot 1.0. It was pretty intricate, because P/C are not handled natively in PowerPivot. Now, with the advent of Denali, Microsoft gave us all the functions…  Read more

Microsoft released the CTP3 of Microsoft SQL Server Code Name “Denali”, as you can see in the SSAS product group blog post. This is the first public release of Denali and after many months of forced silence (I was under…  Read more

I’m sitting at the bloggers table at the Day 1 keynote of PASS Summit 2015 and I try to recap the important news for the BI community. SQL Server Analysis Services 2016 CTP 3 will be available in a few…  Read more

If you have 30 seconds available, please vote the following items on Connect: https://connect.microsoft.com/SQLServer/feedback/details/679618/import-attribute-key-from-ssas-in-powerpivot When you import data coming from an Analysis Services cube in PowerPivot, you cannot import the attribute key value. Only the attribute name is included in…  Read more

Using Visual Studio to author SSAS Multidimensional projects, I was used to copy the project, deploy it with another name and then proceed with updates, until I was satisfied with the final result. Then, working with the two projects side-by-side…  Read more

A new date is available for the PowerPivot workshop I and Marco are delivering all over Europe. On September 19-20, 2011 we will be in Lisbon (Portugal) to present the workshop to Excel users and BI professionals. Moreover, as Denali…  Read more

The 2015 has been an amazing year for Power BI. One year ago, I was commenting on this blog the public preview of Power BI dashboards. A few days ago, Microsoft released the December update of Power BI Desktop and…  Read more

link In many workshops and sessions about PowerPivot the most frequently asked question has always been: how can I automate the PowerPivot Data Refresh in Excel? I talked about that a few weeks ago. The sad answer is that this…  Read more

A BISM Tabular model can be browsed in Excel by using just the standard PivotTable like it was a regular Analysis Services cube (that now we call a Multidimensional model). If you are used to PowerPivot, this seems a limitation,…  Read more

In an Analysis Services cube you can define drillthrough actions on a cube. This feature has been working since SQL 2005 and now it will be available in both BISM Multidimensional and BISM Tabular in the next version of SQL…  Read more