Here’s yet another post in my series on things I think you should be doing in Power BI Copilot AI Instructions. Today: validating values that users enter as filters in their prompts. It’s something of ...

By the time you read this it’s likely the new, standalone Power BI “ Chat with your data ” experience will be available in your tenant. I just enabled it in the tenant the Fabric CAT team uses for ...

If you have a Power BI report with a matrix visual on it it’s quite likely that you’ll want all the levels in the matrix to be fully expanded by default. But did you know that the way you expand all ...

BI User Group Evening–London, June 21st It’s been ages since I’ve organised a BI evening for the UK SQL Server User Group which is bad, I know, but I’ve finally got round to setting one up. It will be ...

Recursive Calculation Problems If you read my blog, and you’re interested in MDX, you should be reading Jeffrey Wang’s blog too – he’s the new Mosha! Anyway, I’ve been having some performance problems ...

Power BI Semantic Model Memory Errors, Part 2: Max Offline Semantic Model Size In the Power BI Service, Import mode models are stored offline and paged into memory only when they are needed – for ...

Once we’ve specified the name of the table in the first parameter of Summarize, we can then supply a list of columns in the table to group by. This list can contain any number of columns, but we can ...