Fabric BI Architecture: Patterns, Workspaces, and Trade-offs
Proposed session for SQLBits 2026TL; DR
The challenge isn't finding a BI architecture pattern—it's choosing one that fits. I'll walk through common patterns, how they translate to Fabric workspaces, and the trade-offs behind each. You'll leave with reference diagrams to adapt.
Session Details
"How should we structure our Fabric workspaces?" It's one of the first questions I get in any engagement, and my answer is always: it depends. I've seen teams pick patterns that look clean on a diagram but fight against them for months. The challenge isn't finding an architecture — it's choosing one that actually fits your situation.
In this session, I'll walk through common BI architecture patterns and how they translate into Fabric workspaces. We'll look at what works, what gets complicated, and where decisions made early can cause friction later, especially when deployment pipelines only support one workspace at a time.
We'll cover:
- Common patterns: separating data engineering and analytics environments, layered architectures, locking down elements with private links
- How workspace structure supports (or fights against) your architecture
- Access control, identities, and who can see what
- Deployment and lifecycle: what changes when you have multiple workspaces
- The trade-offs behind each approach and how to choose
You'll leave with reference architecture diagrams you can adapt, and a clearer sense of how to match your architecture to your organisation's needs. Whether you're designing from scratch or rethinking an existing setup, this session will help you make decisions with your eyes open.
In this session, I'll walk through common BI architecture patterns and how they translate into Fabric workspaces. We'll look at what works, what gets complicated, and where decisions made early can cause friction later, especially when deployment pipelines only support one workspace at a time.
We'll cover:
- Common patterns: separating data engineering and analytics environments, layered architectures, locking down elements with private links
- How workspace structure supports (or fights against) your architecture
- Access control, identities, and who can see what
- Deployment and lifecycle: what changes when you have multiple workspaces
- The trade-offs behind each approach and how to choose
You'll leave with reference architecture diagrams you can adapt, and a clearer sense of how to match your architecture to your organisation's needs. Whether you're designing from scratch or rethinking an existing setup, this session will help you make decisions with your eyes open.
3 things you'll get out of this session
- Common patterns: separating data engineering and analytics environments, layered architectures, locking down elements with private links
- How workspace structure supports (or fights against) your architecture
- Access control, identities, and who can see what
- Deployment and lifecycle: what changes when you have multiple workspaces
- The trade-offs behind each approach and how to choose
Speakers
Prathyusha(Prathy) Kamasani's other proposed sessions for 2026
Building End-to-End Data Analytics Solutions with Microsoft Fabric and Open Data - 2026
Designing Power BI Templates for Adoption - 2026
Fabric Tenant Settings: The Decisions Behind What's Open and What's Closed - 2026
Making Sense of Fabric Capacity: Start, Monitor, Scale - 2026
Prathyusha(Prathy) Kamasani's previous sessions
One dataset and three use cases with Microsoft Fabric
Are you curious about how to leverage Open Data with Fabric? In this demo filled session, I will show you how I import World Bank Open Data into Fabric using different methods: Pipelines, Data factory Gen-II, Notebooks and a mix of all three. Then I will demonstrate how I do modelling using Warehouse, Power BI Dataset model and Notebooks. Finally, I will create stunning reports using Power BI.
By the end of the session, attendees will get an idea of how each artifact would work, why one would use one over other artifacts, and understand how to create an end-to-end solution with Microsoft Fabric
Powering Up Your Power BI Development Workflow with Microsoft Fabric Notebooks
Are you excited about Microsoft Fabric and its Notebooks feature, but also feel overwhelmed by the different languages it supports, this session is for you. You will learn the basics of Python and Spark, and how to use Notebooks to write and run code. You will also discover how to leverage tools like CoPilot to assist you with code suggestions and corrections. Moreover, you will see how to use libraries like SemPy to enrich your Power BI development with advanced analytics. Join Prathy in this session and get ready to explore the possibilities of Notebooks in Microsoft Fabric.