The other day I discovered something new (at least to me) while writing the DAX for a measure in Power BI Desktop: when you insert a new line in your DAX expression using SHIFT-ENTER it also auto-indents the code. I asked a few people if this was new because I was sure I hadn’t seen […]

Read More →

Back in March, with the publication of the Dynamics 365 Release Notes document (which you can download here, halfway down the page), we learned a lot about the roadmap of Power BI; my blog post here summarises the announcements. However, on Twitter Matthew Roche reminded me that it is a living document and indeed it […]

Read More →

About two years ago I wrote a blog post describing how the #table M function can be used to generate tables, but in that post I only covered the functionality I used regularly – namely using #table with a list of column names or a table type in the first parameter. However there two other […]

Read More →

Back in 2012 I wrote a blog post explaining how to handle multi-value parameters in DAX queries in Reporting Services reports. The approach I took back then was basically: Generate a string containing a pipe-delimited list of all the parameter values that the user has selected (I did this in DAX too, but to be […]

Read More →

Pour la seconde année consécutive j’ai la chance d’avoir été sélectionné pour animer une session lors du SQLSaturday Montréal. Pour ceux qui souhaiteraient passer un Week-End dans une ville formidable et passer du bon temps avec nos cousins Francophones, voilà … Lire la suite

Read More →

The SQLSaturday #735 took place in Helsinki last week-end. Great city and amazing people there. For all of you who attended my session about SQL Server inside a Docker container, the PowerPoint Slides and the demo files can be downloaded … Lire la suite

Read More →

As a quick follow-on from last week’s post on how to detect whether query folding is taking place when importing from OData data sources, if you’re importing data from Analysis Services you have a similar problem: how do you know whether query folding is taking place? Ensuring that query folding takes place for as many […]

Read More →