Power BI can’t find a gateway? Here’s what you need to do

by Matthew Adams
Matthew Adams
Matthew Adams
Windows & Software Expert
Matthew is a freelancer who has produced a variety of articles on various topics related to technology. His main focus is the Windows OS and all the things... read more
Affiliate Disclosure

To fix various PC problems, we recommend DriverFix:
This software will keep your drivers up and running, thus keeping you safe from common computer errors and hardware failure. Check all your drivers now in 3 easy steps:

  1. Download DriverFix (verified download file).
  2. Click Start Scan to find all problematic drivers.
  3. Click Update Drivers to get new versions and avoid system malfunctionings.
  • DriverFix has been downloaded by 0 readers this month.

A Power BI gateway establishes a connection between the BI could technology for data analysis and a user’s data source. However, some users can’t find data gateways when they to configure scheduled refreshes. This error message appears for some users: Publishing succeeded, but the published report cannot connect to the data source because we were unable to find a gateway. Please install and configure an enterprise gateway.

Consequently, users can’t publish reports to Power BI when the BI service can’t find a gateway. The gateway is missing, and that’s often due to a user not adding data sources for their gateway. Here are a couple of resolutions for fixing missing Power BI gateways.

How do I add a gateway in Power BI?

1. Configure the Data Source for Gateway

  1. Users can usually fix missing Power BI gateways by adding sources to them. To add a data source to a gateway, click the gear button in the Power BI service.
  2. Click Manage gateways on the gear button’s menu.
  3. Then click the Add Data Source button to open the Data Source Settings shown directly below.Date Source Settings drop-down menu power bi can't find gateway
  4. Enter a data source in the Data Source Name box.
  5. Select a data source type on the Data Source Type drop-down menu.
  6. Then fill out the Server and Database boxes, along with the other details required for the data source.
  7. Click the Add button.
  8. After clicking Add, don’t forget to fill out the Users tab. Click Users and enter the email addresses of anybody who will need to utilize the gateway.

Looking for the best software to collect user data with depth and reliability? Here are the best options.

2. Check the Server and Database Names Match in Power BI Service and Desktop

Note that the server and database details users enter in Data Source Settings within the BI service must exactly match the server and database details entered within Power BI Desktop. For example, if users enter an IP address for the server within BI Desktop and a server name within the Data Source Settings for the BI service, users won’t find the gateway listed when they try to schedule a refresh. So, make sure the server and database details for a gateway match up within Power BI service and the BI Desktop software.

The Data Source Settings tab power bi can't find gateway
So, Power BI users need to remember to configure all data sources for a BI file with the gateway to ensure Power BI can find the gateway and lists it in Scheduled Refresh. If further resolutions are required, users can file a support ticket at the Power BI support page by clicking Create Support Ticket.


idee restoro Still having issues? Fix them with this tool:
  1. Download this PC Repair Tool rated Great on TrustPilot.com (download starts on this page).
  2. Click Start Scan to find Windows issues that could be causing PC problems.
  3. Click Repair All to fix issues with Patented Technologies (Exclusive Discount for our readers).

Restoro has been downloaded by 0 readers this month.

This article covers:Topics: