-
Analyzing table and column size is an important step in optimizing a data model for Power Pivot, Power BI, or Analysis Services Tabular. This article describes VertiPaq Analyzer, an Excel workbook to analyze detailed information extracted from Dynamic Management Views. Read more
-
This article contains a short checklist of what you have to do in order to optimize the memory used by a data model in PowerPivot or in Analysis Services Tabular, including links to tools and resources that can help you… Read more
-
This page contains descriptions and links to necessary tools and resources for DAX and Tabular developers. Read more
-
After many tries, today I came to the conclusion that Analysis Services 2005 SP2 breaks the Excel 2007 calculated member selection feature. I already talked about this issue here, but today I found the way to reproduce the error. This is… Read more
-
I recently talked about memory usage in PowerPivot and previously I wrote about difference modeling options using table normalization or not. Thus, I wondered whether table normalization is a good practice for performance and memory or not. The short answer… Read more
-
You know, selecting calculated members in Excel is not an option. I talked about this issue more than three years ago for the first time: http://www.sqlbi.com/blog/marco/2007/01/31/excel-2007-pivottable-with-calculated-members/ http://www.sqlbi.com/blog/marco/2007/03/07/ssas-2005-sp2-breaks-excel-calculated-member-selection/ http://www.sqlbi.com/blog/marco/2008/12/08/ssas-2008-calculated-members-still-don-t-love-excel-2007/ The upcoming new versions of SQL Server 2008 R2 and Office 2010… Read more
-
I found an issue upgrading an Excel workbook containing PowerPivot data from Excel 2010 to Excel 2013. All CUBEMEMBER and CUBEVALUE functions point to a cube name that has been changed between the two version – you have to no… Read more
-
Many people requested me how to connect to Power Pivot from an external program, without publishing the workbook on SharePoint or on Analysis Services Tabular. I always said it is not possible (for both technical and licensing reasons), but someone… Read more
-
The Detail Rows Expression in a Tabular model provides the user with control over the drillthrough results obtained by showing details of a measure. This article describes typical DAX expressions you can use in this property. Read more
-
The DAX language provides several Time Intelligence functions that simplify writing calculations such as year-to-date (YTD), year-over-year (YOY) and so on. However, if you have a special calendar structure such as a 4-4-5 weeks’ calendar, you need to write your… Read more