Posts

June '25 - Fabric and Power BI preview features

Last up in this month series is a review of the preview features we're seeing drop into both Fabric and Power BI. As always, do remember that it is not recommended to use preview features in production unless absolutely necessary. By using them in production you are carrying the risk of breaking changes, and without SLA level support. First up, Power BI. Power BI Visual calculation updates This month we've seen: Parameter pickers for required parameters when a function template is used. Coloured highlights similar to the way that Excel works. Change in behaviour when using columns in a function so that a value instead of an error is returned. Added visual calculations to the explore view. For me, the largest update in this change is adding the visual calculation option to the explore view. This feature will make it easier to allow train of thought analysis to move into areas not natively supported in the semantic model. Whilst the coloured highlights are welcome, my concern is ...

Power BI - June '25 release notes

 As we approach the end of June, this months release notes have dropped. As with Fabric, expect the GA changes to be relatively light. We're start with the general section. General Sensitivity labels For those using sensitivity labels, do be aware that we're seeing to changes on how these are applied to make collaboration easier. The end result will be the same, but the label travels with the PBIX now.  If you are using sensitivity labels, make sure you check out the blog: Power BI June 2025 Feature Summary | Microsoft Power BI Blog | Microsoft Power BI Reporting Sparklines Sparklines within tables have now gone GA having been in preview since December 2021! It's insane that this has been a preview feature for so long, and is a clear example of why we need SLAs on preview features going GA across both Power BI and Fabric. If this is something that you've been wanting to use, but been able to because of company policy, it's now time that you can go in and start apply...

Fabric June 25 release - GA features

 As we head into July, we get what is likely to be our last major update until Fabcon Vienna. With holiday season and Microsoft's end of financial year, we don't typically see July and August releases, and I wouldn't expect any different this year. For those new to the blog, I post three separate blogs covering Fabric GA features, Power BI GA features, and preview features both combined. This one looks at the release notes that aren't clearly preview (though don't expect massive changes this month as we head into what are typically quieter times for Microsoft). First up is data engineering. Data engineering Notebook version history On the surface this one seems a minor change, but actually it's a massively handy feature. At one time or another, pretty much everyone makes a change that they need to undo but they haven't committed changes to version control as it's code they're still working on and isn't ready for a commit. Until now that meant, in...

An introduction to MCP on Azure

Image
Over the last few weeks I seem to be having more and more conversations about MCP servers. Be it with customers looking at agentic AI solutions, or announcements from the big tech providers.  With this in mind, I thought I'd write this blog to help engineers and architects understand what I've learnt about how they fit into the agentic solutions that data science teams are building today. What are MCP servers? An MCP, or model context protocol, server is ultimately an interpolation layer that makes it easier for data science teams to integrate APIs, data sets, etc into large language model (LLM) solutions.  Within these setups, an API, data set, etc is referred to as a tool. Historically, integrating one tool into an agentic solution has been relatively straight forward; but, that effort doesn't scale linearly. As more and more tools, the complexity rapidly increases - increasing both development and maintenance costs. To solve this challenge, Anthropic introduced MCP. This...

Comparing Databricks Data + AI summit vs Fabric (inc build announcements)

As announcement season comes to an end, we can look at how this weeks big announcements from Databricks line up with Fabric and the roadmap we know about today. Before going into the features from each, it's clear that we are going to have a big tussel between the two. I'll start with the announcements from data + AI summit and then look at any features the Fabric team have announced that wasn't covered. Databricks Data + AI summit Lakebase First up, we have operational databases. Bringing operational systems into the same platforms as insight and analytics is proving to be a big theme currently. One that will simplify solutions, and reduce both data movement and data duplication. Big win for not only customers, but also the sustainability of our data solutions. Databricks offering is Lakebase, a Postgres solution underpinned by Databricks storage platform. Over in Fabric, Microsoft has announced Cosmos DB as the equivalent. Which of these is better is going to be very much...

May '25 - Fabric and Power BI preview features

With the GA features and key build announcements out the way, we now turn our attention to the preview features. Again, I'm not going to cover the key announcements from build in this blog - if you are interested in those, do go have a look at my previous blog on the matter. First up, Power BI. Power BI Copilot and AI As with all things Copilot, for UK readers, please do remember you have to turn on out of region processing - and risk your data being processed in the US. For everyone else in the EU, this isn't an issue (your data is processed in Paris).  AI data schema Part of the challenge we're going to face with Copilot of semantic models is doing all we can to ensure the semantic models they are using are optimised - to help reduce the chances of hallucinations further. AI data schema is one of the tools to do this. With this wizard we are able to: Simplify the schema by disabling tables, columns, measures, and hierarchies. Reducing the data set that Copilot can see. Es...

Fabric - May '25 GA feature summary

Alongside all the key announcements from build, we've had this months may update drop. In this blog, I'm going to focus on the features that have gone GA and aren't covered by my keynote announcement. I'll also drop a separate post for all the features that are still in preview. As always, please do double check that a feature you want to use is definately GA (the Microsoft blog's aren't always clear). Before we start on features, the first announcement is the new Fabric roadmap . Personally, I like the fact we can now see which quarter features are due to go GA - it's a big improvement. Slight grumble on how sparse the GA plans are, but hopefully that's because it's a new tool and we'll start to see more announcements going forwards. Up first, platform changes. Platform New rest APIs and service principal (SPN) support This month we now get a bunch of new APIs to make sure that we're nearly at feature parity with Power BI (only the admin API...