An architecture scenario Imagine separate Sales, Finance, Shared Data, and Executive Analytics workspaces. Sales owns sales transactions, Finance owns budgets, and Shared Data owns common tables such as Customer, Product, and Date. Executive Analytics needs selected data from all three, … Continue reading →
Originally published April 2022; substantially updated July 2026. This post is a complete replacement for and update to my April 2022 post, Power BI Performance Features. That post focused on several performance features that were new or in preview at … Continue reading →
It can feel as if Microsoft has put the Copilot name everywhere, and that is not far from the truth. The important thing to understand is that Microsoft Copilot is not one identical AI assistant copied into every product. It … Continue reading →
The idea behind Fabric OneLake Security (which GA’d on April 2026) is to centralize data access controls at the data layer, rather than configuring security separately for every Fabric experience. You define security once, close to the data in OneLake, … Continue reading →
Once again there were a number of Microsoft Build announcements related to data and AI, and some were very impressive. Below are my favorites. I am prioritizing the data announcements first, because that is where my brain naturally goes (and … Continue reading →
Microsoft Purview can be the best data governance tool in the world, but it will still be useless if people do not know it exists, do not trust the metadata, or do not change the way they work. That is … Continue reading →
Since the release of my book Deciphering Data Architectures: Choosing Between a Modern Data Warehouse, Data Fabric, Data Lakehouse, and Data Mesh, I’ve been fortunate to hear from readers around the world. One question I’ve received frequently is whether the … Continue reading →
What problem is Fabric Ontology trying to solve? For years, most data conversations have started with tables. We ask where the data lives, what columns are available, how the joins work, and whether the data is in a warehouse, lakehouse, … Continue reading →
Model Context Protocol, or MCP, is one of those technical ideas that sounds more complicated than it really is. The easiest way to think about it is this: MCP is to AI what USB was to hardware. Before USB became … Continue reading →
There’s a question I’ve been hearing more and more lately, especially as Copilot, Fabric, and Fabric data agents become part of everyday conversations with customers: will GenAI replace reports and dashboards? It’s a fair question, because on the surface they … Continue reading →
Once your Fabric tenant grows past a few workspaces, data discovery gets weird fast. Duplicates multiply. People stop trusting what they find. And security teams start hearing things like, “I think only the right people have access” (which is never … Continue reading →
A ton of new features for Microsoft Fabric were announced at the Microsoft Fabric Community Conference (FabCon Atlanta 26) last week (see the FabCon keynote here). There were 8000 attendees! Here are all the new data-related features that I found most interesting, … Continue reading →
I hosted this month’s T-SQL Tuesday invitation in which I asked, “What career risks have you taken?” I got some great responses which I’ll recap here, Career risks? Rob Farley Rob took an interesting angle on the idea of career … Continue reading →
In my recent blog post, Building Power BI Reports: Desktop vs Fabric, I talked about the evolving authoring experience in Microsoft Fabric and how report development is increasingly moving into the browser. But that conversation inevitably leads to another architectural … Continue reading →
I’m honored to be hosting T-SQL Tuesday — edition #196. For those who may not know the history, T-SQL Tuesday started back in December 2009 when Adam Machanic (Blog |LinkedIn) sent out the first invitation for what he called a monthly … Continue reading →
Why this comparison feels confusing If you’re a Power BI report author who’s just getting into Microsoft Fabric, you’ve probably asked the same question I hear over and over: am I supposed to stop using Power BI Desktop now? It’s … Continue reading →
A few weeks ago, I found myself staring at a slide full of new Microsoft AI names and thinking… wait a second. Work IQ. Fabric IQ. Foundry IQ. Agent 365. Agent Factory. And that’s before we even get into Copilot … Continue reading →
Organizations increasingly want Snowflake and Microsoft Fabric to coexist without duplicating data or fragmenting governance. With Fabric OneLake and open table formats like Iceberg and Delta, there are now multiple ways to make Snowflake data available inside Fabric—each with different … Continue reading →
I remember a meeting where a client’s CEO leaned in and asked me, “So, we have tons of data… Why can’t we just add AI and call it a day?” He was excited—who isn’t these days? But my team and … Continue reading →
Monitoring costs in Microsoft Fabric can be trickier than it first appears. You might assume it’s just a flat fee per capacity (easy, right?), but real-world usage tends to add complexity. Maybe you pause and resume a capacity, scale it … Continue reading →