{"id":30806,"date":"2024-01-15T13:07:45","date_gmt":"2024-01-15T13:07:45","guid":{"rendered":"https:\/\/chartexpo.com\/blog\/?p=30806"},"modified":"2026-01-29T17:19:24","modified_gmt":"2026-01-29T12:19:24","slug":"data-gateway-in-power-bi","status":"publish","type":"post","link":"https:\/\/chartexpo.com\/blog\/data-gateway-in-power-bi","title":{"rendered":"On-Premises Data Gateway in Power BI: A Complete Guide"},"content":{"rendered":"<p>Ah, the data gateway in Power BI.<\/p>\n<p>It sounds like something out of a sci-fi movie, doesn&#8217;t it?<\/p>\n<p>But, no, it&#8217;s not a gate to another dimension. Nor is it a portal to the underworld. It&#8217;s much more exciting than that. It&#8217;s the magical bridge that connects your Power BI with the promised land of data.<\/p>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/01\/data-gateway-in-power-bi.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/01\/data-gateway-in-power-bi.jpg\" alt=\"Data Gateway in Power BI\" \/><\/a><\/div>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytwYitjZXhwbytQQkk0NjUrU2Fua2V5Kw==\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-power-bi.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytncytjZXhwbytDRTQ2NSs=\" target=\"_blank&quot;\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-google-sheets.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a><a href=\"https:\/\/chartexpo.com\/TrafficTracker\/MTYrYmxvZytzZStjZXhwbytDRTI2NSs=\" target=\"_blank&quot;\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-microsoft-excel.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a><\/div>\n<p>Like a busy bee, it buzzes back and forth between on-premises data and the cloud. It&#8217;s that reliable postman who always delivers on time, ensuring your reports and dashboards are always up-to-date. Not all heroes wear capes, you know.<\/p>\n<p>So, why do we use it, you ask?<\/p>\n<p>Picture this: your data is held hostage in your on-premises servers, yearning for the freedom of the cloud.<\/p>\n<p>Who are you going to call?<\/p>\n<p>Data gateway! This data superhero will liberate your data and make it accessible to Power BI in no time.<\/p>\n<p>Brilliant, isn&#8217;t it?<\/p>\n<p>So, grab your adventurer&#8217;s hat, and let&#8217;s delve into the mysterious world of the Power BI data gateway.<\/p>\n<h3>Table of Content:<\/h3>\n<ol>\n<li><a href=\"#gateway-definition\">What is a Gateway?<\/a><\/li>\n<li><a href=\"#power-bi-gateway-working\">How Does a Gateway Work in Power BI?<\/a><\/li>\n<li><a href=\"#how-does-power-bi-gateway-do\">What Does a Gateway Do in Power BI?<\/a><\/li>\n<li><a href=\"#when-use-power-bi-gateway\">When to use Power BI gateway?<\/a><\/li>\n<li><a href=\"#power-bi-gateway-types\">Types of Power BI Gateway<\/a><\/li>\n<li><a href=\"#power-bi-gateway-requirements-and-considerations\">Requirements and Considerations<\/a><\/li>\n<li><a href=\"#power-bi-gateway-setup\">How to Set Up On-Premises Data Gateway in Power BI?<\/a>\n<ul>\n<li><a href=\"#installing-power-bi-gateway\">Installing the Power BI Gateway<\/a><\/li>\n<li><a href=\"#run-downloaded-file\">Run the Downloaded File and Install<\/a><\/li>\n<li><a href=\"#registering-power-bi-gateway\">Registering the Gateway<\/a><\/li>\n<\/ul>\n<\/li>\n<li><a href=\"#gateway-connection-to-the-dataset\">Gateway Connection to The Dataset<\/a><\/li>\n<li><a href=\"#how-to-use-power-bi-gateway-step-by-step\">How to Analyze Power BI Data Gateway: Step-by-Step<\/a><\/li>\n<li><a href=\"#troubleshooting-power-bi-gateway\">Troubleshooting of Power BI Gateway<\/a><\/li>\n<li><a href=\"#power-bi-gateway-benefits\">Benefits of Using an On-Premises Data Gateway in Power BI<\/a><\/li>\n<li><a href=\"#power-bi-gateway-best-practices\">Power BI Data Gateway Best Practices<\/a><\/li>\n<li><a href=\"#wrap-up\">Wrap Up<\/a><\/li>\n<\/ol>\n<h2 id=\"gateway-definition\">What is a Gateway?<\/h2>\n<p><strong>Definition:<\/strong> An on-premises data gateway in Power BI is like a secure bridge. It connects Power BI to data stored in various places, like on-premises servers or cloud platforms.<\/p>\n<p>This allows Power BI to access, analyze, and update the data, ensuring <a href=\"https:\/\/chartexpo.com\/blog\/power-bi-dashboard-vs-report\" target=\"_blank\" rel=\"noopener noreferrer\">reports and dashboards<\/a> are always current. The data gateway also ensures data security by encrypting the connection and managing access to the data sources.<\/p>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/08\/on-premises-data-gateway.png\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/08\/on-premises-data-gateway.png\" alt=\"on premises data gateway\" width=\"650\" \/><\/a><\/div>\n<h2 id=\"power-bi-gateway-working\">How Does a Gateway Work in Power BI?<\/h2>\n<h3>Gateway Execution flow<\/h3>\n<p>A gateway in Power BI securely connects on-premises data sources to the <a href=\"https:\/\/chartexpo.com\/services\" target=\"_blank\" rel=\"noopener noreferrer\">Power BI service<\/a> in the cloud. It retrieves data from local sources, encrypts it, and transfers it to Power BI for reporting and analysis, enabling scheduled refreshes and live queries without moving data to the cloud.<\/p>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/08\/on-premises-data-gateway-01.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/08\/on-premises-data-gateway-01.jpg\" alt=\"on premises data gateway 1\" width=\"650\" \/><\/a><\/div>\n<h2 id=\"how-does-power-bi-gateway-do\">What Does a Gateway Do in Power BI?<\/h2>\n<p>A gateway in Power BI acts as a secure bridge between on-premises <a href=\"https:\/\/chartexpo.com\/blog\/power-bi-dataset\" target=\"_blank\" rel=\"noopener noreferrer\">data sources<\/a> and the Power BI service in the cloud. It allows data from local servers to be accessed, refreshed, and used in Power BI reports and dashboards, ensuring seamless and secure <a href=\"https:\/\/chartexpo.com\/blog\/power-bi-transform-data\" target=\"_blank\" rel=\"noopener noreferrer\">data transfer<\/a>.<\/p>\n<h2 id=\"when-use-power-bi-gateway\">When to use Power BI gateway?<\/h2>\n<p>Use a Power BI gateway when you need to connect and refresh data from on-premises sources, such as local databases or files, to your Power BI reports and dashboards in the cloud. It&#8217;s essential when your data isn&#8217;t stored in the cloud and you want to maintain secure, real-time, or scheduled access to it within Power BI.<\/p>\n<h2 id=\"power-bi-gateway-types\">Types of Power BI Gateway<\/h2>\n<p>In the context of Power BI, there are two main types of gateways: the On-Premises Data Gateway and the Power BI Gateway for Personal Use. Here&#8217;s a brief overview of each:<\/p>\n<h3>On-Premises Data Gateway in Power BI<\/h3>\n<ul>\n<li><strong>Standard Mode:<\/strong> This mode allows Power BI to connect to on-premises data sources, such as databases, without exposing them directly to the internet. It supports scheduled data refreshes, live queries, and high availability.<\/li>\n<li><strong>Personal Mode:<\/strong> This mode is suitable for individual users or scenarios where there is no need for centralized administration. It allows a single user to <a href=\"https:\/\/chartexpo.com\/blog\/power-bi-connectors\" target=\"_blank\" rel=\"noopener noreferrer\">connect Power BI<\/a> to on-premises data sources from their machine.<\/li>\n<\/ul>\n<h3>Data Gateway in Power BI Gateway for Personal Use<\/h3>\n<p>This gateway is designed for individual users or small-scale scenarios where sharing and collaboration are not the primary focus. It enables a single user to refresh data from on-premises data sources for their use.<\/p>\n<h2 id=\"power-bi-gateway-requirements-and-considerations\">Requirements and Considerations<\/h2>\n<ol>\n<li><strong>System Requirements<\/strong>: Use Windows Server 2012 R2 or later, or Windows 10. Ensure the machine has adequate CPU, RAM, and storage.<\/li>\n<li><strong>Network Configuration<\/strong>: Allow outbound connections to Power BI service URLs and ports (HTTP 80, HTTPS 443). Configure firewalls and proxies accordingly.<\/li>\n<li><strong>Data Source Connectivity<\/strong>: Provide valid credentials and configure data sources correctly within the gateway.<\/li>\n<li><strong>Performance and Security<\/strong>: Allocate sufficient resources and implement security practices, including regular updates and secure storage of recovery keys.<\/li>\n<li><strong>High Availability<\/strong>: Set up gateway clusters for load balancing and redundancy.<\/li>\n<\/ol>\n<h2 id=\"power-bi-gateway-setup\">How to Set Up On-Premises Data Gateway in Power BI?<\/h2>\n<p>Follow these steps to set up a data gateway in Power BI:<\/p>\n<h3 id=\"installing-power-bi-gateway\">Installing the Power BI Gateway<\/h3>\n<p>To install the Power BI Gateway, you can download it directly from the official website at this link or find the download option within the Power BI service under &#8220;Data Gateway.&#8221;<\/p>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/08\/Power-BI-Data-Gateway-1.png\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/08\/Power-BI-Data-Gateway-1.png\" alt=\"on premises data gateway 2\" width=\"502\" \/><\/a><\/div>\n<h3 id=\"run-downloaded-file\">Run the Downloaded File and Install<\/h3>\n<p>Once you run the installation file, you&#8217;ll be prompted to choose the type of gateway you want to install.<\/p>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/08\/Power-BI-Data-Gateway-2.png\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/08\/Power-BI-Data-Gateway-2.png\" alt=\"on premises data gateway 3\" width=\"640\" \/><\/a><\/div>\n<p><span data-type=\"partial\" data-sync=\"plag_match_counter0\">For this example, we&#8217;ll install the on-premises gateway because it supports Live and DirectQuery connections, which are crucial for real-time data access.<\/span><\/p>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/08\/Power-BI-Data-Gateway-3.png\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/08\/Power-BI-Data-Gateway-3.png\" alt=\"on premises data gateway 4\" width=\"640\" \/><\/a><\/div>\n<p>After selecting the gateway type, the installer will download the necessary files and proceed with the installation. You&#8217;ll be asked to choose a folder for the installation; for simplicity, we&#8217;ll use the default folder. The installation process is straightforward, and once completed, you&#8217;ll need to register the gateway.<\/p>\n<h3 id=\"registering-power-bi-gateway\"><strong>Registering the Gateway<\/strong><\/h3>\n<p>To register your gateway, log in with your Power BI account.<\/p>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/08\/Power-BI-Data-Gateway-4.png\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/08\/Power-BI-Data-Gateway-4.png\" alt=\"on premises data gateway 5\" width=\"604\" \/><\/a><\/div>\n<p>You&#8217;ll then have the option to either register a new gateway or migrate\/restore an existing one. For this guide, select &#8220;Register a new gateway&#8221; and continue.<\/p>\n<p>You&#8217;ll need to provide:<\/p>\n<ul>\n<li><strong>Gateway Name<\/strong>: Choose a name that easily identifies the gateway&#8217;s location, such as &#8220;Reza-Vaio-Gateway.&#8221;<\/li>\n<li><strong>Recovery Key<\/strong>: This key is crucial for recovering the gateway in the future. If you need to reinstall or move the gateway to another machine, keeping the recovery key secure is essential.<\/li>\n<\/ul>\n<p>You also have the option to add the gateway to an existing cluster for high availability, but we&#8217;ll leave that unchecked for this example.<\/p>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/08\/Power-BI-Data-Gateway-5.png\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/08\/Power-BI-Data-Gateway-5.png\" alt=\"on premises data gateway 6\" width=\"640\" \/><\/a><\/div>\n<p>After successfully registering, you should see a confirmation that the gateway is online and ready for use.<\/p>\n<h2 id=\"gateway-connection-to-the-dataset\">Gateway Connection to The Dataset<\/h2>\n<ul>\n<li><strong>Gateway Installation<\/strong>: Begin by installing the Power BI Gateway on a server or machine that has access to your local data source.<\/li>\n<li><strong>Data Source Setup<\/strong>: In the Power BI service, navigate to the &#8220;Manage Gateways&#8221; section. Add your on-premises data source, input the required credentials, and configure connection settings.<\/li>\n<li><strong>Dataset Configuration<\/strong>: Open Power BI Desktop, set up your dataset to use the gateway connection, and then publish this dataset to the Power BI service.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/08\/Data-Set-1.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/08\/Data-Set-1.jpg\" alt=\"on premises data gateway 7\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li><strong>Data Source Mapping<\/strong>: In the Power BI service, link the dataset to the data source you configured in the gateway. Ensure the correct data source is selected for your dataset.<\/li>\n<li><strong>Connection Validation<\/strong>: Test the setup by running a data refresh or querying the dataset to confirm that the gateway is correctly connecting to your on-premises data source.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/08\/Data-Set-2.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/08\/Data-Set-2.jpg\" alt=\"on premises data gateway 8\" width=\"650\" \/><\/a><\/div>\n<div>Verify the dataset refresh in Power BI.<\/div>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytwYitjZXhwbytQQkk0NjUrU2Fua2V5Kw==\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-power-bi.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytncytjZXhwbytDRTQ2NSs=\" target=\"_blank&quot;\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-google-sheets.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a><a href=\"https:\/\/chartexpo.com\/TrafficTracker\/MTYrYmxvZytzZStjZXhwbytDRTI2NSs=\" target=\"_blank&quot;\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-microsoft-excel.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a><\/div>\n<h2 id=\"how-to-use-power-bi-gateway-step-by-step\">How to Analyze Power BI Data Gateway: Step-by-Step<\/h2>\n<p>Visualize and analyze data connectivity in Power BI Data Gateway using a <a href=\"https:\/\/chartexpo.com\/charts\/sankey-diagram\" target=\"_blank\" rel=\"noopener\">Sankey chart<\/a>.<\/p>\n<h3>Stage 1: Logging in to Power BI<\/h3>\n<ul>\n<li>Log in to Power BI.<\/li>\n<li>Enter your email. Click the \u201c<strong>Submit<\/strong>\u201d button.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/05\/enter-email-to-login-to-power-bi.jpg\"><img decoding=\"async\" class=\"alignnone size full wp image 4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/05\/enter-email-to-login-to-power-bi.jpg\" alt=\"Enter email to login to Power BI\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>You are redirected to your Microsoft account.<\/li>\n<li>Enter your password and click \u201c<strong>Sign in<\/strong>\u201c.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/05\/enter-password-to-login-to-power-bi.jpg\"><img decoding=\"async\" class=\"alignnone size full wp image 4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/05\/enter-password-to-login-to-power-bi.jpg\" alt=\"Enter Password to login to Power BI\" width=\"363\" \/><\/a><\/div>\n<ul>\n<li>You can choose whether to stay signed in.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/05\/click-on-stay-signed-in.jpg\"><img decoding=\"async\" class=\"alignnone size full wp image 4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/05\/click-on-stay-signed-in.jpg\" alt=\"Click on stay signed in\" width=\"392\" \/><\/a><\/div>\n<div>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li>Once done, the Power BI home screen will open.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/div>\n<h3>Stage 2: <strong>Creating a Data Set and Selecting the Data Set to Use in Your Sankey Chart<\/strong><\/h3>\n<ul>\n<li>Go to the left-side menu and click the \u201c<strong>Create<\/strong>\u201d button.<\/li>\n<li>Select \u201c<strong>Paste or manually enter data<\/strong>\u201c.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/01\/select-paste-or-manually-enter-data-in-power-bi-ce458.jpg\"><img decoding=\"async\" class=\"alignnone size full wp image 4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/01\/select-paste-or-manually-enter-data-in-power-bi-ce458.jpg\" alt=\"select Paste or manually enter data in Power BI ce458\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>We&#8217;ll use the following <a href=\"https:\/\/chartexpo.com\/blog\/analyzing-cash-flow\" target=\"_blank\" rel=\"noopener noreferrer\">cash flow data<\/a> for this example.<\/li>\n<\/ul>\n<table class=\"static\" style=\"table-layout: fixed; overflow-x: auto; border: 1px; font-size: 17px;\">\n<tbody>\n<tr>\n<td width=\"103\"><strong>Total Cost<\/strong><\/td>\n<td width=\"140\"><strong>Company Type<\/strong><\/td>\n<td width=\"210\"><strong>Company Name<\/strong><\/td>\n<td width=\"124\"><strong>Expertise Categories<\/strong><\/td>\n<td width=\"130\"><strong>Expertise<\/strong><\/td>\n<td width=\"74\"><strong>Cost<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"103\">Total Cost<\/td>\n<td width=\"140\">Subcontractor<\/td>\n<td width=\"210\">Skyline Contractors<\/td>\n<td width=\"124\">Mechanical Installation<\/td>\n<td width=\"130\">Plumbing &amp; Heating<\/td>\n<td width=\"74\">15456<\/td>\n<\/tr>\n<tr>\n<td width=\"103\">Total Cost<\/td>\n<td width=\"140\">Subcontractor<\/td>\n<td width=\"210\">Skyline Contractors<\/td>\n<td width=\"124\">Mechanical Installation<\/td>\n<td width=\"130\">Mechanical Work<\/td>\n<td width=\"74\">10159<\/td>\n<\/tr>\n<tr>\n<td width=\"103\">Total Cost<\/td>\n<td width=\"140\">Subcontractor<\/td>\n<td width=\"210\">Onyx General Contractors<\/td>\n<td width=\"124\">Mechanical Installation<\/td>\n<td width=\"130\">Plumbing &amp; Heating<\/td>\n<td width=\"74\">18045<\/td>\n<\/tr>\n<tr>\n<td width=\"103\">Total Cost<\/td>\n<td width=\"140\">Subcontractor<\/td>\n<td width=\"210\">Onyx General Contractors<\/td>\n<td width=\"124\">Mechanical Installation<\/td>\n<td width=\"130\">Mechanical Work<\/td>\n<td width=\"74\">12695<\/td>\n<\/tr>\n<tr>\n<td width=\"103\">Total Cost<\/td>\n<td width=\"140\">Subcontractor<\/td>\n<td width=\"210\">Living Well Remodeling<\/td>\n<td width=\"124\">Mechanical Installation<\/td>\n<td width=\"130\">Plumbing &amp; Heating<\/td>\n<td width=\"74\">14589<\/td>\n<\/tr>\n<tr>\n<td width=\"103\">Total Cost<\/td>\n<td width=\"140\">Subcontractor<\/td>\n<td width=\"210\">Living Well Remodeling<\/td>\n<td width=\"124\">Mechanical Installation<\/td>\n<td width=\"130\">Welding<\/td>\n<td width=\"74\">11456<\/td>\n<\/tr>\n<tr>\n<td width=\"103\">Total Cost<\/td>\n<td width=\"140\">Supplier<\/td>\n<td width=\"210\">Power-up Builders<\/td>\n<td width=\"124\">Raw Material<\/td>\n<td width=\"130\">Cement<\/td>\n<td width=\"74\">20561<\/td>\n<\/tr>\n<tr>\n<td width=\"103\">Total Cost<\/td>\n<td width=\"140\">Supplier<\/td>\n<td width=\"210\">Power-up Builders<\/td>\n<td width=\"124\">Raw Material<\/td>\n<td width=\"130\">Steel<\/td>\n<td width=\"74\">32456<\/td>\n<\/tr>\n<tr>\n<td width=\"103\">Total Cost<\/td>\n<td width=\"140\">Supplier<\/td>\n<td width=\"210\">Five-star Construction<\/td>\n<td width=\"124\">Raw Material<\/td>\n<td width=\"130\">Bricks<\/td>\n<td width=\"74\">10253<\/td>\n<\/tr>\n<tr>\n<td width=\"103\">Total Cost<\/td>\n<td width=\"140\">Supplier<\/td>\n<td width=\"210\">Five-star Construction<\/td>\n<td width=\"124\">Raw Material<\/td>\n<td width=\"130\">Timber<\/td>\n<td width=\"74\">9000<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<ul>\n<li>Paste the above data table in the Power Query Window.<\/li>\n<li>Select the \u201c<strong>Create a dataset only<\/strong>\u201d option.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/01\/create-dataset-in-power-bi-ce465.jpg\"><img decoding=\"async\" class=\"alignnone size full wp image 4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/01\/create-dataset-in-power-bi-ce465.jpg\" alt=\"Create Dataset in Power BI ce465\" width=\"613\" \/><\/a><\/div>\n<ul>\n<li>On the left-side menu, click \u201c<strong>Data Hub<\/strong>\u201c.<\/li>\n<li>Power BI populates the data set list. (If you have not created a data set, refer to the Error! Reference source not found section).<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/01\/click-on-data-hub-ce458.jpg\"><img decoding=\"async\" class=\"alignnone size full wp image 4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/01\/click-on-data-hub-ce458.jpg\" alt=\"Click on Data Hub ce458\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>Choose a data set for the Sankey chart.<\/li>\n<li>PBI populates the screen as shown below:<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/01\/workspace-in-power-bi-ce465.jpg\"><img decoding=\"async\" class=\"alignnone size full wp image 4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/01\/workspace-in-power-bi-ce465.jpg\" alt=\"Workspace in Power BI ce465\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>Click on the \u201c<strong>Create a report<\/strong>\u201d dropdown.<\/li>\n<li>Select \u201c<strong>Start from scratch<\/strong>\u201c.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/01\/create-report-and-start-from-scratch-ce458.jpg\"><img decoding=\"async\" class=\"alignnone size full wp image 4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/01\/create-report-and-start-from-scratch-ce458.jpg\" alt=\"Create Report and start from scratch ce458\" width=\"624\" \/><\/a><\/div>\n<div>\n<ul>\n<li>A Report Canvas screen appears as below:<\/li>\n<\/ul>\n<\/div>\n<div>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/01\/report-canvas-screen-in-power-bi-ce465.jpg\"><img decoding=\"async\" class=\"alignnone size full wp image 4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/01\/report-canvas-screen-in-power-bi-ce465.jpg\" alt=\"Report Canvas screen in Power BI ce465\" width=\"650\" \/><\/a><\/div>\n<\/div>\n<h3>Stage 3: Adding the Power BI Sankey Diagram Extension by ChartExpo<\/h3>\n<ul>\n<li>Creating the Sankey Diagram requires us to use an add-in or Power BI visual from AppSource.<\/li>\n<li>Navigate to the right side of the Power BI dashboard.<\/li>\n<li>Open the Power BI Visualizations panel.<\/li>\n<li>Click the ellipsis symbol (&#8230;) as highlighted in the diagram below. This will import the Power BI Sankey Diagram extension by ChartExpo.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/01\/click-on-to-get-more-visuals-ce465.jpg\"><img decoding=\"async\" class=\"alignnone size full wp image 4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/01\/click-on-to-get-more-visuals-ce465.jpg\" alt=\"click on to get more visuals ce465\" width=\"509\" \/><\/a><\/div>\n<ul>\n<li>The following menu opens:<\/li>\n<li>Select the \u201c<strong>Get more visuals<\/strong>\u201d option.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/01\/get-more-visuals-in-power-bi-ce465.jpg\"><img decoding=\"async\" class=\"alignnone size full wp image 4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/01\/get-more-visuals-in-power-bi-ce465.jpg\" alt=\"get more visuals in Power BI ce465\" width=\"567\" \/><\/a><\/div>\n<ul>\n<li>The following window opens.<\/li>\n<li>Enter \u201c<strong>Sankey Diagram for Power BI by ChartExpo<\/strong>\u201d in the highlighted search box.<\/li>\n<li>You should see the \u201c<strong>Sankey Diagram for Power BI by ChartExpo<\/strong>\u201d, as shown in the image below..<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/05\/sankey-diagram-for-power-bi-by-chartexpo.jpg\"><img decoding=\"async\" class=\"alignnone size full wp image 4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/05\/sankey-diagram-for-power-bi-by-chartexpo.jpg\" alt=\"Sankey Diagram for Power BI by ChartExpo\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>Click the highlighted \u201c<strong>Add<\/strong>\u201d button.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/05\/click-the-add-button.jpg\"><img decoding=\"async\" class=\"alignnone size full wp image 4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/05\/click-the-add-button.jpg\" alt=\"Click the Add button\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>Power BI will add the \u201c<strong>Sankey Diagram for Power BI by ChartExpo<\/strong>\u201d in the visualization panel.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/05\/click-on-sankey-diagram-icon.jpg\"><img decoding=\"async\" class=\"alignnone size full wp image 4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/05\/click-on-sankey-diagram-icon.jpg\" alt=\"Click on Sankey Diagram Icon\" width=\"187\" \/><\/a><\/div>\n<h3>Stage 4: Drawing a Sankey Diagram with ChartExpo&#8217;s Power BI extension<\/h3>\n<ul>\n<li>Select the \u201c<strong>Sankey Diagram for Power BI by ChartExpo<\/strong>\u201d icon in the visualization panel.<\/li>\n<li>The following window opens in the report section of your dashboard:<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/01\/report-section-in-dashboard-ce465.jpg\"><img decoding=\"async\" class=\"alignnone size full wp image 4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/01\/report-section-in-dashboard-ce465.jpg\" alt=\"Report Section in Dashboard ce465\" width=\"297\" \/><\/a><\/div>\n<ul>\n<li>You can resize the visual as needed.<\/li>\n<li>Navigate to the right side of your Power BI dashboard.<\/li>\n<li>You should see \u201c<strong>Fields<\/strong>\u201d next to \u201c<strong>Visualizations<\/strong>\u201c.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/01\/fields-next-to-visualizations-ce465.jpg\"><img decoding=\"async\" class=\"alignnone size full wp image 4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/01\/fields-next-to-visualizations-ce465.jpg\" alt=\"Fields next to visualizations ce465\" width=\"355\" \/><\/a><\/div>\n<ul>\n<li>You&#8217;ll select the fields to use in your Sankey chart here.<\/li>\n<li>The ChartExpo visual needs to be selected, though. Select the field in the following sequence:\n<ul>\n<li>Total Cost<\/li>\n<li>Company Type<\/li>\n<li>Company Name<\/li>\n<li>Expertise Categories<\/li>\n<li>Expertise<\/li>\n<li>Cost<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/01\/select-fields-for-sankey-diagram-ce465.jpg\"><img decoding=\"async\" class=\"alignnone size full wp image 4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/01\/select-fields-for-sankey-diagram-ce465.jpg\" alt=\"Select fields for Sankey diagram ce465\" width=\"174\" \/><\/a><\/div>\n<ul>\n<li>You&#8217;ll be asked for a ChartExpo license key or email address.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/11\/enter-email-for-chartexpo-license-ce430.jpg\"><img decoding=\"async\" class=\"alignnone size full wp image 4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/11\/enter-email-for-chartexpo-license-ce430.jpg\" alt=\"enter email for ChartExpo license ce430\" width=\"531\" \/><\/a><\/div>\n<h3>Stage 5: <strong>Activate <\/strong>your ChartExpo Trial or Apply a Subscription Key<\/h3>\n<ul>\n<li>Select the ChartExpo visual.<\/li>\n<li>You should see three icons below \u201c<strong>Build Visual<\/strong>\u201d in the Visualizations panel.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/05\/build-visual-panel-in-power-bi.jpg\"><img decoding=\"async\" class=\"alignnone size full wp image 4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/05\/build-visual-panel-in-power-bi.jpg\" alt=\"Build visual panel in Power BI\" width=\"203\" \/><\/a><\/div>\n<ul>\n<li>Select the middle icon, \u201c<strong>Format visual<\/strong>\u201c.<\/li>\n<li>The visual properties will be populated as shown below.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/05\/visual-properties-in-power-bi.jpg\"><img decoding=\"async\" class=\"alignnone size full wp image 4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/05\/visual-properties-in-power-bi.jpg\" alt=\"visual properties in Power BI\" width=\"183\" \/><\/a><\/div>\n<ul>\n<li>If you are a new user,\n<ul>\n<li>Type in your email under the section titled \u201cTrial Mode\u201d.<\/li>\n<li>This should be the email address that you used to subscribe to the ChartExpo add-in. It is where your ChartExpo license key will be sent.<\/li>\n<li>Ensure that your email address is valid.<\/li>\n<li>Click \u201cEnable Trial.&#8221; You&#8217;ll get a 7-day trial.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/05\/enter-email-id.jpg\"><img decoding=\"async\" class=\"alignnone size full wp image 4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/05\/enter-email-id.jpg\" alt=\"enter email id\" width=\"180\" \/><\/a><\/div>\n<ul>\n<li>You should receive a welcome email from ChartExpo.<\/li>\n<li>If you do not find the email in your inbox, kindly check your spam folder.<\/li>\n<li>The Sankey Diagram you create under the 7-day trial contains the ChartExpo watermark.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/01\/data-gateway-in-power-bi-1.jpg\"><img decoding=\"async\" class=\"alignnone size full wp image 4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/01\/data-gateway-in-power-bi-1.jpg\" alt=\"Data Gateway in Power BI 1\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>If you have obtained a license key:\n<ul>\n<li>Enter your license key in the \u201c<strong>ChartExpo License Key<\/strong>\u201d textbox in the \u201c<strong>License Settings<\/strong>\u201d section (see below).<\/li>\n<li>Slide the toggle switch next to \u201c<strong>Enable License<\/strong>\u201d to \u201c<strong>On<\/strong>\u201c.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/05\/enter-license-key.jpg\"><img decoding=\"async\" class=\"alignnone size full wp image 4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/05\/enter-license-key.jpg\" alt=\"enter license key\" width=\"197\" \/><\/a><\/div>\n<div>\n<ul>\n<li>To add colors, expand the \u201cLevel Colors\u201d properties and select a color.<\/li>\n<li>Do this to change the color of each node.<\/li>\n<li>All changes are automatically saved.<\/li>\n<\/ul>\n<\/div>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/01\/data-gateway-in-power-bi-2.jpg\"><img decoding=\"async\" class=\"alignnone size full wp image 4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/01\/data-gateway-in-power-bi-2.jpg\" alt=\"Data Gateway in Power BI 2\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>Let&#8217;s add the Prefix (e.g., $ sign) to the chart&#8217;s numeric values.<\/li>\n<li>Expand the &#8220;Stats&#8221; properties. Add the Prefix value (e.g., $ sign).<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/01\/add-prefix-value-ce465.jpg\"><img decoding=\"async\" class=\"alignnone size full wp image 4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/01\/add-prefix-value-ce465.jpg\" alt=\"Add Prefix Value ce465\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>Let&#8217;s add colors to each node. Expand the \u201c<strong>Level Colors<\/strong>\u201d properties and select the colors.<\/li>\n<\/ul>\n<div>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/01\/coloring-sankey-diagram-ce465.jpg\"><img decoding=\"async\" class=\"alignnone size full wp image 4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/01\/coloring-sankey-diagram-ce465.jpg\" alt=\"Coloring Sankey Diagram ce465\" width=\"181\" \/><\/a><\/div>\n<\/div>\n<ul>\n<li>Automatically, all changes will be saved.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/01\/final-data-gateway-in-power-bi.jpg\"><img decoding=\"async\" class=\"alignnone size full wp image 4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/01\/final-data-gateway-in-power-bi.jpg\" alt=\"Final-Data Gateway in Power BI\" width=\"650\" \/><\/a><\/div>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytwYitjZXhwbytQQkk0NjUrU2Fua2V5Kw==\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-power-bi.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytncytjZXhwbytDRTQ2NSs=\" target=\"_blank&quot;\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-google-sheets.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a><a href=\"https:\/\/chartexpo.com\/TrafficTracker\/MTYrYmxvZytzZStjZXhwbytDRTI2NSs=\" target=\"_blank&quot;\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-microsoft-excel.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a><\/div>\n<h4>Insights<\/h4>\n<ul>\n<li>The procurement cost at Level 1 amounts to $155K.<\/li>\n<li>At Level 2, of the total cost of $155K, $72.3K (46.7%) was allocated to the supplier, while $82.4K (53.3%) was spent on subcontractors.<\/li>\n<li>Moving to Level 3, the $72.3K supplier cost was divided between two companies: Power-up Builder and Five-star Construction, charging $53.0K and $19.3K, respectively.<\/li>\n<li>The subcontractor cost of $82.4K was distributed among three companies: Skyline Contractors, Onyx General Contractors, and Living Well Remodeling. They charged $25.6K, $30.7K, and $26.0K, respectively, for their services.<\/li>\n<li>At Level 4, the supplier companies provided raw materials for procurement, totaling $72.3K. The companies specializing in Mechanical Installations accounted for approximately $82.4K.<\/li>\n<li>Among the $72.3K raw material cost, cement, steel, bricks, and timber accounted for $20.6K, $32.5K, $10.3K, and $9K, respectively.<\/li>\n<li>From the $82.4K mechanical installation cost, Plumbing Heating, Mechanical Work, and Welding accounted for $48.1K, $22.9K, and $11.5K, respectively.<\/li>\n<\/ul>\n<h2 id=\"troubleshooting-power-bi-gateway\">Troubleshooting of Power BI Gateway<\/h2>\n<ul>\n<li><strong>Check Gateway Status<\/strong>: Ensure the gateway is online. You can verify this in the Power BI service under &#8220;Manage Gateways.&#8221; If it&#8217;s offline, restart the gateway service on the host machine.<\/li>\n<li><strong>Network Connectivity<\/strong>: Confirm that the gateway can access both the on-premises data source and the <a href=\"https:\/\/chartexpo.com\/blog\/power-bi-cloud\" target=\"_blank\" rel=\"noopener noreferrer\">Power<\/a><a href=\"https:\/\/chartexpo.com\/blog\/power-bi-cloud\" target=\"_blank\" rel=\"noopener noreferrer\">\u00a0BI cloud<\/a> service. Check for firewall or proxy settings that might be blocking connections.<\/li>\n<li><strong>Update the Gateway<\/strong>: Make sure you&#8217;re using the latest version of the gateway. Outdated software can cause compatibility issues.<\/li>\n<li><strong>Review Logs<\/strong>: Logs can be accessed from the gateway installation directory and provide detailed information on what might be causing the problem.<\/li>\n<li><strong>Resource Utilization<\/strong>: Check the machine hosting the gateway for high CPU or memory usage, which could affect performance. Consider upgrading hardware or balancing the load by adding more gateways to a cluster.<\/li>\n<li><strong>Reconfiguration<\/strong>: If configuration settings have changed, you may need to reconfigure the gateway, including updating data source credentials or network settings.<\/li>\n<li><strong>Recovery Key Issues<\/strong>: If you encounter issues with the recovery key, ensure you have it stored securely. Without it, recovering or moving the gateway can be difficult.<\/li>\n<\/ul>\n<h2 id=\"power-bi-gateway-benefits\">Benefits of Using an On-Premises Data Gateway in Power BI<\/h2>\n<p>Using a data gateway in Power BI offers a plethora of benefits:<\/p>\n<ul>\n<li><strong>Data accessibility<\/strong>: With a data gateway for Power BI, you can summon data from anywhere. On-premises, cloud, you name it, and it&#8217;s at your fingertips.<\/li>\n<li><strong>Real-time data<\/strong>: No more waiting for yesterday&#8217;s news. The Power BI data gateway serves up real-time data faster than a barista whips up a latte.<\/li>\n<li><strong>Data security<\/strong>: Your data gets the royal treatment. It&#8217;s wrapped in layers of encryption and access control, ensuring it doesn&#8217;t fall into the wrong hands.<\/li>\n<li><strong>Data scalability<\/strong>: Think of the data gateway as the elastic waistband, accommodating your expanding data empire. As your data grows, it grows with it.<\/li>\n<li><strong>Reduced latency<\/strong>: Forget the buffering wheel of frustration. The Power BI gateway slashes waiting times, so your reports load faster than a hot knife through butter.<\/li>\n<li><strong>Scheduled data refresh<\/strong>: Automation is the name of the game. Set schedules, and your data gets a spa day, refreshing itself without bothering you.<\/li>\n<li><strong>Hybrid cloud solutions<\/strong>: The data gateway bridges the gap between on-premises and cloud data, supporting a seamless integration of hybrid solutions.<\/li>\n<li><strong>Ease of use<\/strong>: It&#8217;s not just for the IT wizards. Anyone can wield the power of the data gateway with its user-friendly setup and management.<\/li>\n<li><strong>Cost-efficiency<\/strong>: Centralized data management means fewer data duplicates and less resource wastage.<\/li>\n<li><strong>Enhanced collaboration<\/strong>: It&#8217;s the ultimate team player, allowing multiple folks to work on the same data. As a result, it promotes collaboration and smarter <a href=\"https:\/\/chartexpo.com\/blog\/data-driven-decision-making\" target=\"_blank\" rel=\"noopener noreferrer\">decision-making<\/a>.<\/li>\n<\/ul>\n<h2 id=\"power-bi-gateway-best-practices\">Power BI Data Gateway Best Practices<\/h2>\n<ol>\n<li><strong>Deployment<\/strong>: Install the gateway on a dedicated, high-performance machine close to your data sources. Avoid using a personal computer or a virtual machine with limited resources.<\/li>\n<li><strong>Redundancy<\/strong>: Set up multiple gateways in a cluster for load balancing and failover. This ensures continuous availability even if one gateway fails.<\/li>\n<li><strong>Security<\/strong>: Use strong passwords and encrypt credentials within the gateway. Limit access to the gateway configuration to authorized personnel only.<\/li>\n<li><strong>Updates<\/strong>: Regularly update the gateway software to the latest version. This ensures compatibility with Power BI updates and includes performance improvements and security patches.<\/li>\n<li><strong>Monitoring<\/strong>: Keep an eye on gateway performance using the monitoring tools in Power BI and track results through <a href=\"https:\/\/chartexpo.com\/tools\/power-bi-custom-visuals\" target=\"_blank\" rel=\"noopener\">Power BI charts<\/a>, helping identify and resolve issues like high CPU usage or slow query performance.<\/li>\n<\/ol>\n<h2>FAQs<\/h2>\n<h3>What is a data gateway in Power BI?<\/h3>\n<p>A data gateway in Power BI is a bridge connecting Power BI to on-premises or cloud-based data sources. It facilitates secure data retrieval, refresh, and sharing, ensuring up-to-date and accessible reports and dashboards.<\/p>\n<h3>What are the types of gateways in Power BI?<\/h3>\n<p>Power BI offers two types of gateways:<\/p>\n<ol>\n<li><strong>On-Premises Data Gateway:<\/strong> Connects to on-premises data sources securely, enabling data access and refresh from within your organization&#8217;s network.<\/li>\n<li><strong>Power BI Gateway (Personal Mode):<\/strong> Designed for individual use, it allows limited data access and refresh within your personal space.<\/li>\n<\/ol>\n<h3>How do I create a gateway in Power BI?<\/h3>\n<p>To create a gateway in Power BI:<\/p>\n<ol>\n<li>Download the Power BI Gateway installer.<\/li>\n<li>Run the installer.<\/li>\n<li>Configure the gateway using Power BI credentials.<\/li>\n<li>Add data sources and configure settings.<\/li>\n<li>Define data source permissions for users.<\/li>\n<li>Your gateway is ready for use.<\/li>\n<\/ol>\n<h4 id=\"wrap-up\">Wrap Up<\/h4>\n<p>Using a data gateway in Power BI is not a mere technicality; it&#8217;s a strategic imperative. It&#8217;s the bridge that connects your data dots, making the entire data landscape accessible and actionable.<\/p>\n<p>The data gateway in Power BI is the ticket to a seamless data-driven journey. It grants you access to data spread across domains, on-premises, or in the cloud. Real-time data becomes more than a dream. It turns into a reality, empowering you with insights that can change the game.<\/p>\n<p>Security, the crown jewel of data, remains intact with the data gateway. The gateway encrypts and guards the data channels. Furthermore, scalability ensures that, as your data universe expands, the gateway grows with it, no sweat.<\/p>\n<p>Reduced latency ensures your data responses are as swift as thought, while scheduled refreshes bring automation into play. Hybrid cloud solutions unite the best of both worlds &#8211; a modern-day diplomatic marvel.<\/p>\n<p>What&#8217;s even more beautiful? It&#8217;s easy to use, making data accessible to the non-tech-savvy. And lastly, enhanced collaboration fosters teamwork and informed decision-making.<\/p>\n<p>Do not hesitate.<\/p>\n<p>Embrace the Power BI gateway and ChartExpo today to unlock the full potential of your data.<\/p>\n","protected":false},"excerpt":{"rendered":"<p><p>Explore Data Gateway in Power BI with our guide. It connects Power BI to data stored in various places, like on-premises servers or cloud platforms<\/p>\n&nbsp;&nbsp;<a href=\"https:\/\/chartexpo.com\/blog\/data-gateway-in-power-bi\"><\/a><\/p>","protected":false},"author":1,"featured_media":30814,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1017],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\r\n<title>On-Premises Data Gateway in Power BI: A Complete Guide -<\/title>\r\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"https:\/\/chartexpo.com\/blog\/data-gateway-in-power-bi\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:title\" content=\"On-Premises Data Gateway in Power BI: A Complete Guide -\" \/>\r\n<meta name=\"twitter:description\" content=\"Explore Data Gateway in Power BI with our guide. It connects Power BI to data stored in various places, like on-premises servers or cloud platforms\" \/>\r\n<meta name=\"twitter:image\" content=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/01\/feature-ce465-200x200-1.jpg\" \/>\r\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"23 minutes\" \/>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"On-Premises Data Gateway in Power BI: A Complete Guide -","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:\/\/chartexpo.com\/blog\/data-gateway-in-power-bi","twitter_card":"summary_large_image","twitter_title":"On-Premises Data Gateway in Power BI: A Complete Guide -","twitter_description":"Explore Data Gateway in Power BI with our guide. It connects Power BI to data stored in various places, like on-premises servers or cloud platforms","twitter_image":"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/01\/feature-ce465-200x200-1.jpg","twitter_misc":{"Written by":"admin","Est. reading time":"23 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/chartexpo.com\/blog\/data-gateway-in-power-bi","url":"https:\/\/chartexpo.com\/blog\/data-gateway-in-power-bi","name":"On-Premises Data Gateway in Power BI: A Complete Guide -","isPartOf":{"@id":"http:\/\/localhost\/blog\/#website"},"datePublished":"2024-01-15T13:07:45+00:00","dateModified":"2026-01-29T12:19:24+00:00","author":{"@id":"http:\/\/localhost\/blog\/#\/schema\/person\/6aceeb7c948a3f66ff6439ce5c24a280"},"breadcrumb":{"@id":"https:\/\/chartexpo.com\/blog\/data-gateway-in-power-bi#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/chartexpo.com\/blog\/data-gateway-in-power-bi"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/chartexpo.com\/blog\/data-gateway-in-power-bi#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"http:\/\/localhost\/blog"},{"@type":"ListItem","position":2,"name":"On-Premises Data Gateway in Power BI: A Complete Guide"}]},{"@type":"WebSite","@id":"http:\/\/localhost\/blog\/#website","url":"http:\/\/localhost\/blog\/","name":"","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/localhost\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"http:\/\/localhost\/blog\/#\/schema\/person\/6aceeb7c948a3f66ff6439ce5c24a280","name":"admin","url":"https:\/\/chartexpo.com\/blog\/author\/admin"}]}},"_links":{"self":[{"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/posts\/30806"}],"collection":[{"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/comments?post=30806"}],"version-history":[{"count":15,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/posts\/30806\/revisions"}],"predecessor-version":[{"id":58427,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/posts\/30806\/revisions\/58427"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/media\/30814"}],"wp:attachment":[{"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/media?parent=30806"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/categories?post=30806"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/tags?post=30806"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}