The Data Engine Room

After last nights keynote, we've so many announcements and new features to digest that it's going to take a few blog posts to get through everything. Given that I'm going to split the announcements to cover: Keynote, Power BI, Fabric, Purview, and preview features. Let's get started. For this blog, if you have a specific feature you want to know more about do have a look at Arun's blog.  Unless it's a really major preview announcement, I'm going to focus on features that have gone GA - the reason, without doing a risk/reward evaluation, I personaly take the view that preview features shouldn't be used in production. That means for the majority, the preview features need to be considered in future roadmap plans but are unlikely to be used today. Up first, copilot. Co-pilot The big announcement in this space is that Copilot is now available at all SKU levels! This is a big one for the SME sector that couldn't justify the cost of an F64 SKU. Now you too...

Some of you will be familiar with dynamic row level security (DRLS) in PowerBI. For those that aren't, DRLS allows us to use the email address of the user that is logged into the service via their Entra account. With this email address, and corresponding email address in our semantic model, we can dynamically filter the semantic model to only show the data that user could see. The result, we can use one report suite to serve the same content to country, region, and global teams whilst simultaneously providing the necessary security around sensitive data. Now back in the world of Power BI, that was really easy. We fired up Power BI desktop, went into manage security roles, and added the necessary DAX: Now in Fabric, that still works exactly the same way as it always has for import and DirectQuery semantic models. However, it's not so straight forward for DirectLake semantic models. Why? The challenge is that a number of features break DirectLake connections and force the model b...