Power BI End-to-End Architecture

January 5, 2021 By Mike Carlo

Melissa Coates of Coates Data Strategies has produced a new version of the Power BI End-to-End architecture document. If you haven’t seen this document it is definitely worth a read.

Summary of Changes

If you’d like to watch a quick webinar of the updates to the document you can watch it here.

Twitter Announcement

Here is the original announcement and release via twitter.

https://twitter.com/SQLChick/status/1346112838964801543

If you’d like to download the latest document you can find it here:
https://www.coatesdatastrategies.com/diagrams

Note: The diagram can be downloaded as a PDF and as an Image.

How it started / How it’s going

If you are on social media at all you will see meme’s about How it started vs. How it’s going. In the thread of Melissa’s tweet we have a fun image showing the progression of Power BI End-to-End architectures. The number of changes since 2015 is absolutely stunning. Power BI has grown up a lot since 2015. That being said, I’m greatly encouraged to see the Microsoft Power BI team pushing amazing new features.

Learn More about Power BI End-to-End

A one page document can contain a lot of information about Power BI. However, it can’t capture every aspect of Power BI. Thus, if you’d like to learn more about Power BI and it’s Administration, Please check out Melissa’s Training. The Power BI Development and Governance Workshop is a deep dive for users who need to administer Power BI.

Conclusion

We hope you enjoy this great document to use or share with your team. I’m confident that you will find areas of interest or learn about new ways to leverage Power BI.

Special thanks to Melissa Coates for participating in the quick webinar around the Power BI End-to-End architecture.

Jun 10, 2026

Microsoft Build Recap – Ep.535

Mike and Tommy recap Microsoft Build 2026 through a Power BI and Fabric lens, focusing on the announcements that matter most for report builders, semantic models, and agent-driven app development. They unpack why Rayfin, Replit integration, OneLake, and new Fabric skills signal a shift from asking AI for answers toward using agents to create real production artifacts.

Jun 5, 2026

CI/CD Automation with Agents – Ep.534

Mike and Tommy explore how agents can simplify CI/CD in Fabric by helping teams work through Git workflows, merge conflicts, validation, and deployment automation. They also compare deployment pipelines with Git-based approaches and explain why small, testable automations are the safest way to start.

Jun 3, 2026

Claude Design & Power BI Embedded – Ep.533

Mike and Tommy explore how Claude Design, agentic workflows, and HTML wireframes could reshape report prototyping for Power BI teams. They also debate where today’s tooling still falls short, especially for Power BI Desktop users who need practical ways to turn context, design ideas, and embedded experiences into working reports.