A Fine Slice Of SQL Server
Koen Verbeeck notes a new default:
The Power BI Enhanced Report Format (PBIR) will soon become the default, and that’s a good thing because it significantly makes git integration easier. You can already enable it in the preview features of Power BI Desktop (also enable PBIP and TMDL to make git integration of the model itself much easier).
Read on to see the administrative setting associated with this, as well as reasons why you should keep it on.
Leave a CommentTzvia Gitlin Troyna announces a new feature:
The new Eventhouse Endpoint for Fabric Data Warehouse extends this same architecture to structured data sources, allowing users to:
- Query Fabric Data Warehouse tables in real-time using KQL.
- Leverage schema mirroring for warehouse tables.
- Unify analytics across Lakehouse and Fabric Data Warehouse without duplicating data.
Even if I don’t expect many data platform practitioners to use KQL and even though I’m morally opposed to the Fabric Data Warehouse (short version: Lakehouses and Warehouses in Fabric should be the same thing, not two separate things), I’d still consider this a step forward. It does provide a new integration point between two services that have been annoyingly isolated.
Leave a CommentVictoria Holt lays out the news:
Real-Time Analytics with Synapse Real-Time Intelligence
- The new Synapse Real-Time Intelligence in Fabric allows streaming data from operational databases to be analyzed instantly.
- This supports use cases like fraud detection, predictive maintenance, and personalized recommendations.
Ah, thank goodness they’re re-using the name Synapse for something that has nothing to do with Azure Synapse Analytics. Makes sense when you’re running Microsoft Service Fab–, err, App Fab–, err, Fabric.
Leave a CommentIn this blog post, I’ll highlight the new zero-ETL, zero-copy sources in OneLake, deeper interoperability between OneLake and Microsoft Foundry, and new tools to help admins manage capacity, security, and governance at scale. Together, these updates further cement Fabric as the ideal data platform for your mission-critical workloads—open, integrated, secure, and built to connect every part of your data estate to the intelligence your business needs.
Read on to see some of the latest from Ignite.
Leave a CommentThe November 2025 Fabric release introduces several major updates, including the general availability of SQL database, Cosmos DB, and enhanced mirroring support for key data sources such as SQL Server, Cosmos DB, and PostgreSQL.
This month also brings new AI-driven features like Copilot sidecar chat tools and real-time data exploration, as well as crucial platform enhancements such as Azure DevOps cross-tenant support, improved security permissions in OneLake, and expanded connectivity through new connectors and developer tooling. These updates are designed to empower users with greater flexibility, intelligence, and control across the Fabric platform.
When the table of contents is roughly three pages, you know it’s either Ignite or Build.
Leave a CommentAnna Hoffman and Idris Motiwala make an announcement:
SQL is everywhere and Microsoft is innovating to deliver a unified experience across on-premises, cloud, and SaaS. One SQL unifies your data estate, bringing platform consistency, performance at scale, advanced security, and AI-ready tools together in one seamless experience, and SQL database in Fabric is no exception to that. At Microsoft Ignite, we’re thrilled to announce SQL database in Microsoft Fabric is officially Generally Available!
This is definitely a fluffy post, though Anna does have some linked videos that go into more detail.
Leave a CommentJon Vöge wants to write multiple records at a time:
Having presented a few sessions on Translytical Task Flows at conferences in the past moths, there is one major recurring question:
How do you write-back multiple records at once?
If you ask me, the questions of bulk write-back/writing back multiple records at once can be understood as two separate user stories, which sound similar, but are technically different:
Click through for those two questions as well as the answer to the first.
Leave a CommentReitse Eskens troubleshoots an issue:
Today was a very interesting day at a customer’s site, where I had some trouble determining why the OneLake security wasn’t functioning as I expected. Spoiler alert: a part was me, and a part had to do with setting up my testing account.
Click through to see what happened and for two Fabric Ideas to improve how column-level and row-level security work.
Leave a CommentAs companies adopt Microsoft Fabric, the distance between backend artifact and Semantic Model is smaller than ever, and it feels more obvious than ever to push some of those local transformations to your Fabric Storage item of choice.
The question is. How do you do that? There are many options:
Read on for those options. Jon focuses on one for people with less database experience.
Leave a CommentPradeep Srikakolapu says good riddance:
In our earlier announcement, we shared that newly created data warehouses, lakehouses and other items in Microsoft Fabric would no longer automatically generate default semantic models. This change allows customers to have more control over their modeling experience and to explicitly choose when and how to create semantic models.
Starting November 20, 2025, Power BI *default* semantic models are disconnected from their item and become independent semantic models.
Click through for an overview of those changes and how you can get rid of the default models you may still have hanging around.
Leave a Comment