If you already installed Analysis Services 2016, you should change the MemoryHeapType setting. There is a new default value (-1), which is an automatic choice that currently applies a new hybrid allocator (which has the number 5 as a value). It should  Read more

Microsoft Press released a free eBook you can already download , Introducing Microsoft Power BI , which I and Alberto Ferrari wrote in the last few months. Please note it is a very introductive book, don’t expect an inside-out. As we wrote in the introduction:  Read more

I wrote many articles and white papers about implementing many-to-many relationships in Analysis Services – for both Multidimensional and Tabular models. For the latter, the same techniques are also useful in Power Pivot and Power BI. With the recent  Read more

With the release of Microsoft SQL Server 2016 , there are several options to use Analysis Services Tabular. SQL Server Standard : it includes Analysis Services Tabular, and it is available in two licensing models: Server + Client Access License (CAL)  Read more

Two years ago I and Alberto Ferrari spent time discussing techniques to calculate new and returning customers, and we wrote the result of our study in the New and Returning Customer article in DAX Patterns web site and book . During one of the Mastering  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, it does  Read more

I wrote this blog post with Alberto Ferrari . A few days ago, during the Build conference, Microsoft announced the availability, although still in preview, of Power BI Embedded . In a few words, Power BI Embedded lets you embed Power BI reports in your  Read more

I wrote an article about Time Intelligence in Power BI Desktop to explain how to fix measures using DAX functions for time intelligence when you have a data model where the relationship uses surrogate keys. THe short description is that all the time intelligence  Read more

Today I observed an issue on a notebook where Excel 2016 was installed and then removed, going back to Excel 2013. After this operation, workbooks having a Power Pivot data model were working correctly by navigating data in PivotTables, but any operation  Read more

The latest version of Power Pivot Utils v 1.05 has a new feature that deserves the immediate upgrade: you can list unused columns ! Thanks to Idan Cohen and Amir Hefetz for their contribute to the macros developed by Bertrand d’ARBONNEAU!  Read more