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

Today I come into a nice bug (misfeature?) of SSIS 2008 and I’d like to share it with you. Let’s start from the beginning: One of the keys to make something speedy is to parallelize it. In TableDifference I read…  Read more

<rant mode=”funny”> Most of the time I submitted an issue to Microsoft Connect, I got a “it’s by design” answer. I’ve been always irritated by this sentence because they don’t admit in this way that they have a bug. Today,…  Read more

I just submitted a suggestion feedback to SQL Server development team. It is very bad for the user to be forced to see measures under their physical measure groups. There are a lot of reasons for which a customer would…  Read more

The DAX query syntax allows you to insert a parameter by using the @ symbol. EVALUATE CALCULATETABLE(     ‘Product Subcategory’,     ‘Product Category’[Product Category Name] = @Category ) Depending on the client and on the driver you are using to…  Read more

Yesterday I lost at least an hour (but only for a coincidence I haven’t lose more hours) because I came across a bug of Analysis Services 2000. If you put a single quote or a double quote inside a comment, the whole…  Read more

A couple of weeks ago, I wrote a blog post about MCSM for BI certification. This raised an interesting discussion about the reasons why such a certification does not exists, whether it was really necessary, what it should include, and…  Read more

I received this request in many courses, messages and also forum discussions: having an Analysis Services Tabular model, it would be nice being able to extract a correspondent PowerPivot data model. In order of priority, here are the specific feature…  Read more

If you think PowerPivot and Tabular are good tools but sometime the design tools are not fast/complete/flexible enough, please consider voting this suggestion on Connect to request a textual representation Tabular or PowerPivot Data Models. This is the simplest way…  Read more

We (I found the issue, Chris created the repro) detected a possible bug using DirectSlice and MeasureExpression.We just posted it here: https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=455732 The issue could be very dangerous resulting in wrong query results on cells affected by DirectSlice property and MeasureExpression,…  Read more