Unable to Connect to gateway in power bi service

Question

Hello All,
I published a dataset coming from SQL server to the power bi service and while trying to connect the gateway, I am getting this error and not able to do so. Can you please help.
Data Source Credentials also greyed out.

Answer 1

The error occurs because the on-premises SQL Server data source isn’t correctly configured on the gateway, or the connection details/credentials don’t match what was used in Power BI Desktop. To resolve it, configure a matching data source on the gateway and ensure valid credentials.

Follow these steps in Power BI service:

1. Go to Settings (gear icon) → Manage connections and gateways.
2. Select the gateway cluster (PBI_Gateway) and choose New to add a data source.
3. On New connection:
   • Select On-premises.
   • Enter the Gateway cluster name.
   • Enter a Connection name.
   • Set Data Source Type to SQL Server.
4. Under data source information, enter Server and Database values that exactly match what was used in Power BI Desktop (including using the same form such as SERVER\INSTANCE, machine name, or IP address). If Desktop used desktop-1smpqqm\sqlexpress and python_etl_pipeline, use those exact values.
5. Under Authentication method, choose Windows or Basic (SQL Authentication) as appropriate and enter a username and password that can connect to that SQL Server database.
6. Save the data source.
7. Ensure the account that owns the dataset is listed under the Users tab of this data source so it can use the gateway.
8. Return to the dataset’s Settings → Gateway and cloud connections and select this gateway/data source. The status should change from “Not configured correctly” once the server/database names and credentials match.

If connection still fails:

• Confirm the gateway machine can connect to the SQL Server instance directly (for example, using SQL tools from that machine).
• If the error indicates invalid credentials, verify the username/password and that the account has permission on the specified database.
• If the error indicates the database can’t be opened, verify the database name and permissions.

These steps align with the requirements that the server and database names must match between Desktop and the gateway configuration, and that valid credentials and user access are required for the gateway to appear and work for the dataset.

---

References:

• Add or remove a gateway data source
• Refresh data from an on-premises SQL Server database
• Manage a SQL Server data source
• Troubleshoot on-premises data gateways

Answer 2

I added personal gateway and configure to the personal gateway. It is working now with Personal Gateway.