I’ve finally updated my Power BI Architecture Diagram to include some of the new features that are now available and will soon be available. There are three new updates I made to the diagram in v4.
Download the Power BI Architecture Diagram v4
Download the Power BI Architecture Diagram Legend
First and most importantly, I updated the Power BI logo in the diagram to the latest version of the logo!
Secondly, I included Power BI Dataflows in the diagram tagged #6. Power BI Dataflows are used to ingest, transform, integrate, and enrich big data by defining data source connections, ETL logic, refresh schedules, and more. Data is stored as entities in the Common Data Model in Azure Data Lake Storage Gen2. Dataflow entities can be consumed as a data source in Power BI and by using Power BI Desktop. Read more about Dataflows here.
Lastly, I also included item #14 to illustrate the upcoming capability Power BI users will have to directly access Power BI hosted data models via XMLA. This will allow you to connect to the Analysis Services data models using Tableau, Qlik, SSRS, SSMS, Dax Studio, SQL Server Profiler and other tools. Initially only read-access will be supported. Eventually write-access will be supported, meaning that I’ll be able to refresh Power BI data models using other client tools. This capability is not currently available at the time of me writing this blog post, but stay tuned.
And don’t forget to download the updated legend that goes with the Power BI Architecture Diagram used to describe and explain the components.
Thoughts and feedback?
Take a look at the diagram and let me know your thoughts and any feedback you have! And if you found it useful, leave a comment and let me know and share it with your colleagues!
Video demo?
What would you like to see in a demo?
SharePoint Server shows to connect with Power BI Server, but there isn’t a mapping of SharePoint Online to Power BI Online. I would have placed SharePoint Online next to Onedrive as well.
Ok that’s good feedback. Thank you.
I updated the diagram to illustrate SharePoint Online and Teams as embed targets for Power BI.
This is very cool. What tool did you use to create the diagram? Also missing are all the other data sources from Dynamics platform (for that matter all the other connectors that make it a universal tool)
I used Visio to make the diagram. I just don’t have enough real estate in the diagram to include all the other connectors.
Would be cool if you provided the Visio, so we could customize it to specific scenarios.
Great work, looks like you have a bug in the design missing live query connection from Azure to BowerBI in the top left hand side.