Continuing my series of posts on Power BI Copilot and the type of things you should be including in AI Instructions, today I ...

Without a doubt the most important new feature in Power BI Copilot is AI Instructions: it opens up an immense number of possibilities but it also starts off as a blank slate, which raises the question ...

Continuing my series of posts on Power BI Copilot and the type of things you should be including in AI Instructions, today I want to talk about helping the end user understand the scope of the data: ...

As you probably know, I work on the Fabric Customer Advisory Team at Microsoft. Apart from advising customers a lot of our team’s time is spent collecting feedback about Fabric and sending it back to ...

As you probably know, I work on the Fabric Customer Advisory Team at Microsoft. Apart from advising customers a lot of our team’s time is spent collecting feedback about Fabric and sending it back to ...

Almost every time I write MDX calculations, I end up using scoped assignments – it’s by far the easiest way to control where your calculations work inside a cube. However making sure that your scoped ...

Here’s what they have to say about it: Red Gate SSAS Compare is a tool for Microsoft Business Intelligence professionals that generates XMLA scripts for partial or complete SSAS cube deployment.

Top N reports are an extremely common requirement: my customers are always trying to find their top 10 products or sales people or geographies by some measure or other. Luckily this type of report is ...

A blog about Microsoft Fabric, Power BI, SQL Server Analysis Services (Multidimensional and Tabular), MDX, DAX, Power Pivot, Power Query and Excel for BI ...

Those of you who have worked with SSAS Multidimensional for a reasonable amount time will, no doubt, be very familiar with the NameColumn and KeyColumns properties of an attribute (if you’re not, see ...

In the previous post in this series I looked at how MDX set expressions could be used inside Excel to give you total control over what appears on the rows and columns axis of your PowerPivot ...

Today marks eight years since my first ever post on this blog, and every year on this date I write a review of what’s happened to me professionally and what’s gone on in the world of Microsoft BI in ...