In yet another entry in my series on what you should be doing in Power BI Copilot AI Instructions, in this post I want to ...

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 ...

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 ...

CROSSJOIN () The Crossjoin () function takes two or more sets and returns a set of tuples representing all possible combinations of items in these sets. So, for example, the crossjoin of the two sets ...

It looked like fun. It’s actually described by Google themselves as an OLAP system here. I don’t agree with this classification – I think it’s better to describe it as an analytical database – but it ...

Steve Wozniak comes to SQLBits 8! Today, the SQLBits committee made a really big announcements about SQLBits 8: we’ve got Steve Wozniak coming! Yes, Steve Wozniak, co-founder of Apple and tech ...

From this we can see that individual customers only bought from us once or twice. Now, for any date, let’s create a calculation that will find what the value of the last purchase by any given customer ...

Despite its name the MDX Script Debugger doesn’t actually help you to debug individual MDX expressions or calculations. What it does is clear the MDX Script of the cube then allow you to step through ...