Power BI Architecture Diagram v2 is Now Available

Update: My Power BI architecture diagram v3 is now available! Head over to here get the latest version!

I finally finished putting together version 2 of my Power BI architecture diagram. I previously put together an architecture diagram but as fast as Power BI is changing, v1 of the diagram was quickly obsolete. I always wanted to come back and add more to the diagram to make it more complete but now that SQL Server 2016 is generally available and enhancements have been made to Power BI to facilitate integration with Excel and SSRS, it made sense to do another diagram.

The reason I originally created this diagram was to use as a tool during conversations with my customers. But I’ve also used the diagram in other presentations and found it beneficial while teaching about how Power BI works. I wanted to make this resource available to others for their benefit. So here’s v2.

Click here to download a .zip file with the .pdf and .png files.

Power BI architecture v2

I’ve included a few new things to make the diagram up to date with the latest changes to Power BI, SQL Server Reporting Services, and Excel.
This document includes components to illustrate:

  • Publishing Power BI desktop files and Excel workbooks to Reporting Services
  • Publishing Excel workbooks to a Power BI site
  • Browsing Power BI data models with Excel
  • Publishing Reporting Services content to the Report Server
  • Browsing Reporting Services mobile reports and KPIs using Power BI apps

Feel free to download this content and use it in your presentations, discussions, and for your own learning. I hope you find it useful and if you do, share it with a friend.


Do you have any feedback on this diagram or anything you’d like to see me change? Leave a comment or let me know! Thanks!

11 thoughts on “Power BI Architecture Diagram v2 is Now Available”

  1. Nice visual. Question. On first blush this seems to imply that SSAS (Tabular for us) doesn’t leverage the PBI Gateway as its line goes directly to/thru PBI Desktop or Excel. But, I thought Tabular models shared via Content Packs (via the Gateway) was preferred – so that users could create reports w/o needing the desktop tools. Am I missing something here?

Leave a Reply to Andrew Mackay (@mistophiles) Cancel reply