Topic: Power Pivot

       Page 7 of 177 blog posts
blog post –

Power Query now imports relationships #powerquery #powerpivot

The December release of Power Query preview (version 2.9.3502.261) introduced an interesting feature: when you import multiple tables in the data model, relationships existing between tables in the data source are automatically detected and added to the  Read more

blog post –

Format your #dax code with DAX Formatter

When you write a DAX formula that is not trivial, you end up having a complex expression that is not really readable. I think that the same problem affect in part all Excel users, but in Excel you can easily split a formula in many steps, using different  Read more

blog post –

Excel 2013 stand-alone now includes #powerpivot

This time Microsoft listened to the many complaints received since Excel 2013 release and the stand-alone version of Excel now includes Power Pivot and Power View! This is a very important news because there were customer who didn’t upgrade from Excel  Read more

blog post –

Understanding #DAX Query Plans for #powerpivot and #tabular

Alberto Ferrari wrote a very interesting white paper about DAX query plans. We published it on a page where we’ll gather articles and tools about DAX query plans: http://www.sqlbi.com/topics/query-plans/ I reviewed the paper and this is the result of  Read more