-
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
-
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. Read more
-
In PowerPivot you can import data from several sources and it is often the case that you import a DateTime column from a database. From an analytical point of view, you usually make analysis over dates (day/month/year/quarter/week) and over time… Read more
-
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
-
There is less than one week (and only a few seats) available to register to the first PowerPivot Workshop that will be held in the Netherlands on December 1-2, 2010. I and Alberto spent the last days to refine the… 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
-
When you install Analysis Services Denali, chances are that you create an instance for Tabular that is not the default instance for Analysis Services. When you try to create a Tabular project, you might get the following error: You cannot… Read more
-
In PowerPivot you can import data from several sources and it is often the case that you import a DateTime column from a database. From an analytical point of view, you usually make analysis over dates (day/month/year/quarter/week) and over time… Read more
-
Yesterday I spent the longest day at this TechEd: we talked with many people at Community Night until 9pm and I have to say that just a few months after Analysis Services 2012 has been released, there are many people… Read more
-
Javier Guillén wrote several blog post about how to implement certain common calculations in PowerPivot. It is interesting to read his posts not only because of the solutions he propose, but also because he uses several techniques that can be… Read more