{"id":19528,"date":"2018-07-15T04:10:17","date_gmt":"2018-07-15T04:10:17","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=19528"},"modified":"2019-09-27T16:28:05","modified_gmt":"2019-09-27T10:58:05","slug":"power-bi-architecture","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/power-bi-architecture\/","title":{"rendered":"Power BI Architecture &#8211; 7 Components Explained with Working"},"content":{"rendered":"<p>In order to learn technology, you must be handy with its architecture. If you are not aware of the architecture of the technology, you won&#8217;t be able to become a master of it.\u00a0Under this <em>Power BI architecture tutorial by DataFlair<\/em>, we&#8217;re going to learn from the basics then we will\u00a0gradually move upwards, learn about its components and how it works. We&#8217;ll also understand how does the front end and back end of Power BI work to provide all its unique functionalities and features for data analysis.<\/p>\n<p>Let&#8217;s start and have a thorough understanding of the concept.<\/p>\n<h2>Power BI Architecture<\/h2>\n<p><em>Power BI is a business suite that includes several technologies that work together.<\/em> To deliver outstanding business intelligence solutions, Microsoft Power BI technology consists of a group of components such as:<\/p>\n<ul>\n<li>Power Query (for data mash-up and transformation)<\/li>\n<li>Power BI Desktop (a companion development tool)<\/li>\n<li>Power BI Mobile (for Android, iOS, Windows phones)<\/li>\n<li>Power Pivot (for in-memory tabular data modeling)<\/li>\n<li>Power View (for viewing data visualizations)<\/li>\n<li>Power Map (for visualizing 3D geo-spatial data)<\/li>\n<li>Power Q&amp;A (for natural language Q&amp;A)<\/li>\n<\/ul>\n<p>In simple terms, a Power BI user takes data from various data sources such as <strong>files, Azure source, online services, DirectQuery or gateway sources.<\/strong> Then, they work with that data on a client development tool such as <em><strong><a href=\"https:\/\/data-flair.training\/blogs\/power-bi-desktop\/\">Power BI Desktop<\/a>.<\/strong><\/em> Here, the imported data is cleaned and transformed according to the user\u2019s needs.<\/p>\n<p>Once the data is transformed and formatted, it is ready to use in making visualizations in a report. A report is a collection of visualizations like <em>graphs, charts, tables, filters, and slicers.<\/em><\/p>\n<p>Moving on to the chain of processes, you can publish the reports created in Power BI desktop on two kinds of platforms; <strong>Power BI Service<\/strong> and <em><a href=\"https:\/\/data-flair.training\/blogs\/power-bi-report-server\/\"><strong>Power BI Report Server<\/strong><\/a><\/em>.<\/p>\n<p>Power BI Service is a cloud-based public platform whereas Power BI Report Server is an on-premise platform protected by firewall security.<\/p>\n<p>You can create dashboards on these platforms by pinning visualizations from your published reports. Lastly, share your dashboards and reports and collaborate with other users from your organization or outside, using delivery options like a <em>web-browser, Power BI on iPad, tablets, laptops, phones,<\/em> etc.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/07\/Power-BI-architecture-overview.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-70020\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/07\/Power-BI-architecture-overview.png\" alt=\"Power BI architecture overview\" width=\"1022\" height=\"590\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/07\/Power-BI-architecture-overview.png 1022w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/07\/Power-BI-architecture-overview-150x87.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/07\/Power-BI-architecture-overview-300x173.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/07\/Power-BI-architecture-overview-768x443.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/07\/Power-BI-architecture-overview-520x300.png 520w\" sizes=\"auto, (max-width: 1022px) 100vw, 1022px\" \/><\/a><\/p>\n<h3>Components of Power BI Architecture<\/h3>\n<p>Let us learn about the components of Power BI architecture in detail.<\/p>\n<h4>1. Data Sources<\/h4>\n<p>An important component of Power BI is its vast range of data sources. You can import data from files in your system, cloud-based online data sources or connect directly to live connections. If you import from data on-premise or online services there is a limit of 1 GB. Some commonly used data sources in Power BI are:<\/p>\n<ul>\n<li>Excel<\/li>\n<li>Text\/CSV<\/li>\n<li>XML<\/li>\n<li>JSON<\/li>\n<li>Oracle Database<\/li>\n<li>IBM DB2 Database<\/li>\n<li>MySQL Database<\/li>\n<li>PostgreSQL Database<\/li>\n<li>Sybase Database<\/li>\n<li>Teradata Database<\/li>\n<li>SAP HANA Database<\/li>\n<li>SAP Business Warehouse server<\/li>\n<li>Amazon Redshift<\/li>\n<li>Impala<\/li>\n<li>Google BigQuery (Beta)<\/li>\n<li>Azure SQL Database<\/li>\n<li>Salesforce Reports<\/li>\n<li>Google Analytics<\/li>\n<li>Facebook<\/li>\n<li>GitHub<\/li>\n<\/ul>\n<p><em><strong>You must learn about <a href=\"https:\/\/data-flair.training\/blogs\/data-sources-for-power-bi\/\">Power BI Data Sources<\/a> thoroughly<\/strong><\/em><\/p>\n<h4>2. Power BI Desktop<\/h4>\n<p>Power BI Desktop is a client-side tool known as a companion development and authoring tool.<\/p>\n<p>This desktop-based software is loaded with tools and functionalities to <em>connect to data sources, transform data, data modeling and creating reports.<\/em><\/p>\n<p>You can download and install Power BI Desktop in your system for free. Using Power BI Desktop features, one can do <em>data<\/em> <em>cleansing, create business metrics and data models, define the relationship between data, define hierarchies, create visuals and publish reports.<\/em><\/p>\n<h4>3. Power BI Service<\/h4>\n<p>Power BI Service is a web-based platform from where you can<em> share reports made on Power BI Desktop, collaborate with other users, and create dashboards.<\/em><\/p>\n<p>It is available in three versions:<\/p>\n<ul>\n<li>Free version<\/li>\n<li>Pro version<\/li>\n<li>Premium version<\/li>\n<\/ul>\n<p>Power BI Service is also known as, <strong>\u201cPower BI.com\u201d<\/strong>,<strong> \u201cPower BI Workspace\u201d,<\/strong> <strong>\u201cPower BI Site\u201d<\/strong> and <strong>\u201cPower BI Web Portal\u201d<\/strong>. This component also offers advanced features like <em>natural language Q&amp;A<\/em> and <em>alerts<\/em>.<\/p>\n<h4>4. Power BI Report Server<\/h4>\n<p>The Power BI Report Server is similar to the Power BI Service. The only difference between these two is that Power BI Report Server is an on-premise platform. It is used by organizations who do not want to publish their reports on the cloud and are concerned about the security of their data.<\/p>\n<p>Power BI Report Server enables you to create dashboards and share your reports with other users following proper security protocols. To use this service, you need to have a Power BI Premium license.<\/p>\n<p><em><strong>Want to learn more about it? Check out the\u00a0<a href=\"https:\/\/data-flair.training\/blogs\/power-bi-report-server\/\">Power BI Report Server Tutorial<\/a><\/strong><\/em><\/p>\n<h4>5. Power BI Gateway<\/h4>\n<p>This component is used to connect and access on-premise data in secured networks. Power BI Gateways are generally used in organizations where data is kept in security and watch. Gateways help to extract\u00a0out such data through secure channels to Power BI platforms for analysis and reporting.<\/p>\n<p><em><strong>Wait! Have you checked our Tutorial on\u00a0<a href=\"https:\/\/data-flair.training\/blogs\/power-bi-gateway\/\">Power BI Gateway<\/a><\/strong><\/em><\/p>\n<h4>6. Power BI Mobile<\/h4>\n<p>Power BI Mobile is a native Power BI application that runs on iOS, Android, and Windows mobile devices. For viewing reports and dashboards, these applications are used.<\/p>\n<h4>7. Power BI Embedded<\/h4>\n<p>Power BI Embedded offers APIs which are used to embed visuals into custom applications.<\/p>\n<h3>Working of Power BI Architecture<\/h3>\n<p>Now that we have understood the individual components of Power BI, let us learn how do all of these components work in tandem. We will understand the Power BI architecture with the help of this diagram.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/07\/power-BI-Architecture-Diagram.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-70395\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/07\/power-BI-Architecture-Diagram.jpg\" alt=\"Power BI Architecture Diagram\" width=\"1816\" height=\"2576\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/07\/power-BI-Architecture-Diagram.jpg 1816w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/07\/power-BI-Architecture-Diagram-106x150.jpg 106w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/07\/power-BI-Architecture-Diagram-211x300.jpg 211w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/07\/power-BI-Architecture-Diagram-768x1089.jpg 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/07\/power-BI-Architecture-Diagram-722x1024.jpg 722w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/07\/power-BI-Architecture-Diagram-520x738.jpg 520w\" sizes=\"auto, (max-width: 1816px) 100vw, 1816px\" \/><\/a><\/p>\n<p>If you look closely, the diagram has numbering done on each component in the architecture. Also, note that the lower half part is the on-premise part and the upper half part depicts the on-cloud services.<\/p>\n<p>To begin with, what forms the starting point or source of all the data flowing into Power BI components are the data sources. Power BI has the get data feature using which you can connect to different kinds of data sources like <em>files, on-premise or on-cloud databases, direct connections,<\/em> etc. Data connections are established from these data sources to authoring tools such as Power BI Desktop.<\/p>\n<p><strong>On-Premise<\/strong><\/p>\n<p>Power BI Desktop is a companion development, authoring, and publishing tool. You can import data from data sources to Power BI Desktop and use it to create reports and then publish them on a Power BI Service or Power BI Report Server.<\/p>\n<p>You can also publish Excel workbooks directly using Power BI Publisher for Excel to the Power BI Report Server. The SQL Server Data tools and Report Publisher help in <em>creating datasets, KPIs, mobile reports, paginated reports,<\/em> etc. The reports from all kinds of reports are published to the Power BI Report Server from where they are distributed to the end-users.<\/p>\n<p><strong>On-Cloud<\/strong><\/p>\n<p>An important component in Power BI architecture is the Power BI Gateway. The Power BI Gateway acts as a secure channel to transport data from on-premise data sources to on-cloud apps or sites.<\/p>\n<p>On the cloud side of the architecture, resides a lot of components. Like a complete Power BI suite having <em>dataflows, datasets, dashboards, reports, Power BI Embedded, Power BI Premium,<\/em> etc. You can embed your reports and dashboards into <em>Teams, SharePoint, custom applications,<\/em> etc. There are on-cloud data sources as well that connects to Power BI tools via direct connections.<\/p>\n<p>At last, there is a layer of authenticated users who share the published reports and dashboard and collaborate with one another to make educated decisions based on the insights. There are different kinds of users who consume Power BI reports and dashboards and connect through<em> web browsers, Excel, third-party tools, and mobile devices<\/em> (iOS, Windows, Android apps).<\/p>\n<h3>Power BI Service<\/h3>\n<p>As we have learned in the earlier sections, all the reports that you create in Power BI Desktop are published on a cloud platform known as Power BI Service.<\/p>\n<p>Users can access the reports and dashboards from Power BI Service using client platforms like websites, mobile devices, etc. This means that every client who wants to access content created on Power BI needs to interact with Power BI Service. And so, we must take a look under the hood and learn how Power BI Service works.<\/p>\n<p>Power BI Service\u2019s architecture consists of two parts:<\/p>\n<ul>\n<li>A front end<\/li>\n<li>A back end<\/li>\n<\/ul>\n<p><strong>Front End cluster<\/strong><\/p>\n<p>The front end also called the web front-end cluster acts as an intermediary between clients and the back end. The front end services are used for establishing an initial connection and authenticating clients using Azure Active Directory. The Azure Active Directory stores user identities.<\/p>\n<p>Along with this, Azure Traffic Manager is used to direct user requests to the nearest data center after authentication. Once a client\/user is authenticated, the <strong>Azure Content Delivery Network (CDN)<\/strong> distributes static Power BI content\/files to users.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/07\/Frontend-Cluster-in-PowerBI-architecture.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-70021\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/07\/Frontend-Cluster-in-PowerBI-architecture.png\" alt=\"Frontend Cluster in Power BI architecture\" width=\"1022\" height=\"601\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/07\/Frontend-Cluster-in-PowerBI-architecture.png 1022w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/07\/Frontend-Cluster-in-PowerBI-architecture-150x88.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/07\/Frontend-Cluster-in-PowerBI-architecture-300x176.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/07\/Frontend-Cluster-in-PowerBI-architecture-768x452.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/07\/Frontend-Cluster-in-PowerBI-architecture-520x306.png 520w\" sizes=\"auto, (max-width: 1022px) 100vw, 1022px\" \/><\/a><\/p>\n<p><strong>Back End Cluster<\/strong><\/p>\n<p>The Power BI services at the back end take care of<em> visualizations, datasets, storage, reports, data connections, data refreshing, and other interactions<\/em> with Power BI. At the back-end, a web client has only two direct points of interaction, <strong>Azure API Management<\/strong>, and <strong>Gateway Role<\/strong>. These two components are responsible for <em>load balancing, authentication, authorization, routing,<\/em> etc.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/07\/Backend-Cluster-in-PowerBI-architecture.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-70022\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/07\/Backend-Cluster-in-PowerBI-architecture.png\" alt=\"Backend Cluster in Power BI architecture\" width=\"1022\" height=\"615\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/07\/Backend-Cluster-in-PowerBI-architecture.png 1022w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/07\/Backend-Cluster-in-PowerBI-architecture-150x90.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/07\/Backend-Cluster-in-PowerBI-architecture-300x181.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/07\/Backend-Cluster-in-PowerBI-architecture-768x462.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/07\/Backend-Cluster-in-PowerBI-architecture-520x313.png 520w\" sizes=\"auto, (max-width: 1022px) 100vw, 1022px\" \/><\/a><\/p>\n<h3>Working of Power BI Service<\/h3>\n<ul>\n<li>Power BI stores its data in two main repositories; <strong>Azure block storage<\/strong> and <strong>Azure SQL database<\/strong>. Azure block storage stores the datasets uploaded by users and all the metadata and system-related data is stored in the Azure SQL database.<\/li>\n<li>After Azure API Management authenticates a user request, it is sent to the Gateway Role. The Gateway Role processes the requests and directs them to suitable components like <em>Presentation Role, Background Job Processing Role, Data Role, and Data Movement Role.<\/em><\/li>\n<li>For instance, the Presentation Role handles all the visualization related queries like for dashboards and reports.<\/li>\n<li>For all the data related queries, the request is sent by the Gateway Role to the Data Role or Data Movement Role.<\/li>\n<li>Power BI Service back end uses Azure Service Bus to connect on-premise <a href=\"https:\/\/en.wikipedia.org\/wiki\/Datasource\">datasources<\/a> with the cloud. Azure Service Bus receives all the requests to fetch data from the on-premise data source. Then it processes the request and executes the query on the on-premise data source to retrieve data from it to the cloud service.<\/li>\n<li>The Azure Service Fabric manages all the microservices and components associated with running Power BI.<\/li>\n<li>Azure AD Cache helps in real-time reporting using the data stored in the in-memory of the Power BI system.<\/li>\n<\/ul>\n<h2>Summary<\/h2>\n<p>This concludes our tutorial on Power BI architecture. Here, we learned about all the important components of Power BI architecture, saw how they work together. We also learned in detail about the functioning of the Power BI Service and understood its working.<\/p>\n<p><b><i>Time to move ahead to the next article by DataFlair &#8211; <a href=\"https:\/\/data-flair.training\/blogs\/power-bi-components\/\">Power BI Components<\/a><\/i><\/b><\/p>\n<p>We hope this information was helpful. Do leave your valuable feedback in the comment section below. In case of any difficulties, our experts will help you in the best possible way.<span hidden class=\"__iawmlf-post-loop-links\" data-iawmlf-links=\"[{&quot;id&quot;:1882,&quot;href&quot;:&quot;https:\\\/\\\/en.wikipedia.org\\\/wiki\\\/Datasource&quot;,&quot;archived_href&quot;:&quot;http:\\\/\\\/web-wp.archive.org\\\/web\\\/20250904202804\\\/https:\\\/\\\/en.wikipedia.org\\\/wiki\\\/Datasource&quot;,&quot;redirect_href&quot;:&quot;&quot;,&quot;checks&quot;:[{&quot;date&quot;:&quot;2025-12-10 06:37:09&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2025-12-13 19:35:09&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2025-12-17 10:31:56&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2025-12-20 15:49:01&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2025-12-24 03:37:50&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2025-12-28 04:12:11&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2025-12-31 05:42:14&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-01-03 20:45:59&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-01-07 01:17:18&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-01-10 13:36:40&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-01-14 06:44:04&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-01-18 04:23:19&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-01-21 05:21:45&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-01-24 05:35:04&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-01-28 09:43:32&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-02-01 12:15:24&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-02-04 19:54:13&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-02-08 03:49:42&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-02-11 15:57:35&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-02-15 04:28:51&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-02-19 13:01:40&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-02-23 07:00:36&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-02-26 07:11:06&quot;,&quot;http_code&quot;:404},{&quot;date&quot;:&quot;2026-03-02 14:21:08&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-03-07 00:09:11&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-03-10 11:26:38&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-03-13 12:32:40&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-03-17 01:07:16&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-03-20 06:25:24&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-03-23 09:06:42&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-03-26 09:16:00&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-03-29 17:36:59&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-04-02 03:04:47&quot;,&quot;http_code&quot;:429},{&quot;date&quot;:&quot;2026-04-05 19:47:16&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-04-09 18:26:02&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-04-14 07:46:02&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-04-17 09:11:50&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-04-20 13:47:57&quot;,&quot;http_code&quot;:429},{&quot;date&quot;:&quot;2026-04-23 19:21:57&quot;,&quot;http_code&quot;:404},{&quot;date&quot;:&quot;2026-04-28 01:47:26&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-05-01 03:44:09&quot;,&quot;http_code&quot;:429},{&quot;date&quot;:&quot;2026-05-05 09:59:09&quot;,&quot;http_code&quot;:429},{&quot;date&quot;:&quot;2026-05-08 10:27:11&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-05-11 13:05:18&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-05-15 07:47:43&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-05-18 08:33:26&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-05-21 17:04:24&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-05-25 11:33:19&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-05-29 12:07:48&quot;,&quot;http_code&quot;:404},{&quot;date&quot;:&quot;2026-06-01 19:20:10&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-06-07 05:59:22&quot;,&quot;http_code&quot;:404},{&quot;date&quot;:&quot;2026-06-10 11:45:02&quot;,&quot;http_code&quot;:404},{&quot;date&quot;:&quot;2026-06-14 06:11:45&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-06-17 20:59:04&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-06-22 05:02:18&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-06-26 17:21:02&quot;,&quot;http_code&quot;:404},{&quot;date&quot;:&quot;2026-06-30 08:49:54&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-07-04 00:27:45&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-07-07 06:00:49&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-07-10 06:58:53&quot;,&quot;http_code&quot;:503},{&quot;date&quot;:&quot;2026-07-13 11:03:54&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-07-16 13:16:13&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-07-20 05:14:00&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-07-23 06:09:28&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-07-27 00:29:35&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-07-30 08:29:58&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-08-03 06:06:38&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-08-06 08:21:46&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-08-09 17:41:57&quot;,&quot;http_code&quot;:200}],&quot;broken&quot;:false,&quot;last_checked&quot;:{&quot;date&quot;:&quot;2026-08-09 17:41:57&quot;,&quot;http_code&quot;:200},&quot;process&quot;:&quot;done&quot;}]\"><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In order to learn technology, you must be handy with its architecture. If you are not aware of the architecture of the technology, you won&#8217;t be able to become a master of it.\u00a0Under this&#46;&#46;&#46;<\/p>\n","protected":false},"author":5,"featured_media":70397,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[42],"tags":[20989,9603,20990,9724,20988],"class_list":["post-19528","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-power-bi","tag-data-sources","tag-power-bi-architecture","tag-power-bi-direct-query","tag-power-bi-gateway","tag-power-bi-service"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Power BI Architecture - 7 Components Explained with Working - DataFlair<\/title>\n<meta name=\"description\" content=\"Learn about the Power BI architecture with its components, working and Power BI service along with its working. Power BI has the get data feature using which you can connect to different kinds of data sources like files, on-premise or on-cloud databases, direct connections.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/data-flair.training\/blogs\/power-bi-architecture\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Power BI Architecture - 7 Components Explained with Working - DataFlair\" \/>\n<meta property=\"og:description\" content=\"Learn about the Power BI architecture with its components, working and Power BI service along with its working. Power BI has the get data feature using which you can connect to different kinds of data sources like files, on-premise or on-cloud databases, direct connections.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/power-bi-architecture\/\" \/>\n<meta property=\"og:site_name\" content=\"DataFlair\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataFlairWS\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-07-15T04:10:17+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-09-27T10:58:05+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/power-bi-architecture-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"802\" \/>\n\t<meta property=\"og:image:height\" content=\"420\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"DataFlair Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:site\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DataFlair Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Power BI Architecture - 7 Components Explained with Working - DataFlair","description":"Learn about the Power BI architecture with its components, working and Power BI service along with its working. Power BI has the get data feature using which you can connect to different kinds of data sources like files, on-premise or on-cloud databases, direct connections.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/data-flair.training\/blogs\/power-bi-architecture\/","og_locale":"en_US","og_type":"article","og_title":"Power BI Architecture - 7 Components Explained with Working - DataFlair","og_description":"Learn about the Power BI architecture with its components, working and Power BI service along with its working. Power BI has the get data feature using which you can connect to different kinds of data sources like files, on-premise or on-cloud databases, direct connections.","og_url":"https:\/\/data-flair.training\/blogs\/power-bi-architecture\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2018-07-15T04:10:17+00:00","article_modified_time":"2019-09-27T10:58:05+00:00","og_image":[{"width":802,"height":420,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/power-bi-architecture-1.jpg","type":"image\/jpeg"}],"author":"DataFlair Team","twitter_card":"summary_large_image","twitter_creator":"@DataFlairWS","twitter_site":"@DataFlairWS","twitter_misc":{"Written by":"DataFlair Team","Est. reading time":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/power-bi-architecture\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/power-bi-architecture\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/7f83c342f5d1632d6f7b4b0b0f447823"},"headline":"Power BI Architecture &#8211; 7 Components Explained with Working","datePublished":"2018-07-15T04:10:17+00:00","dateModified":"2019-09-27T10:58:05+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/power-bi-architecture\/"},"wordCount":1809,"commentCount":2,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/power-bi-architecture\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/power-bi-architecture-1.jpg","keywords":["Data Sources","Power Bi Architecture","power bi direct query","power bi gateway","Power BI Service"],"articleSection":["Power BI Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/power-bi-architecture\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/power-bi-architecture\/","url":"https:\/\/data-flair.training\/blogs\/power-bi-architecture\/","name":"Power BI Architecture - 7 Components Explained with Working - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/power-bi-architecture\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/power-bi-architecture\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/power-bi-architecture-1.jpg","datePublished":"2018-07-15T04:10:17+00:00","dateModified":"2019-09-27T10:58:05+00:00","description":"Learn about the Power BI architecture with its components, working and Power BI service along with its working. Power BI has the get data feature using which you can connect to different kinds of data sources like files, on-premise or on-cloud databases, direct connections.","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/power-bi-architecture\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/power-bi-architecture\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/power-bi-architecture\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/power-bi-architecture-1.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/power-bi-architecture-1.jpg","width":802,"height":420,"caption":"power bi architecture"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/power-bi-architecture\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Home","item":"https:\/\/data-flair.training\/blogs\/"},{"@type":"ListItem","position":2,"name":"Power BI Tutorials","item":"https:\/\/data-flair.training\/blogs\/category\/power-bi\/"},{"@type":"ListItem","position":3,"name":"Power BI Architecture &#8211; 7 Components Explained with Working"}]},{"@type":"WebSite","@id":"https:\/\/data-flair.training\/blogs\/#website","url":"https:\/\/data-flair.training\/blogs\/","name":"DataFlair","description":"Learn Today. Lead Tomorrow.","publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/data-flair.training\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/data-flair.training\/blogs\/#organization","name":"DataFlair","url":"https:\/\/data-flair.training\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","width":106,"height":48,"caption":"DataFlair"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataFlairWS\/","https:\/\/x.com\/DataFlairWS","https:\/\/www.linkedin.com\/company\/dataflair-web-services-pvt-ltd\/","https:\/\/www.youtube.com\/user\/DataFlairWS"]},{"@type":"Person","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/7f83c342f5d1632d6f7b4b0b0f447823","name":"DataFlair Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/4cf3a74600d131330b8c481d519afd1574093ed89f6d3396a95393ad223eb7cd?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/4cf3a74600d131330b8c481d519afd1574093ed89f6d3396a95393ad223eb7cd?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4cf3a74600d131330b8c481d519afd1574093ed89f6d3396a95393ad223eb7cd?s=96&d=mm&r=g","caption":"DataFlair Team"},"description":"DataFlair Team creates expert-level guides on programming, Java, Python, C++, DSA, AI, ML, data Science, Android, Flutter, MERN, Web Development, and technology. Our goal is to empower learners with easy-to-understand content. Explore our resources for career growth and practical learning.","url":"https:\/\/data-flair.training\/blogs\/author\/dfteam1\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/19528","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/comments?post=19528"}],"version-history":[{"count":6,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/19528\/revisions"}],"predecessor-version":[{"id":70398,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/19528\/revisions\/70398"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/70397"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=19528"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=19528"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=19528"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}