topic Re: I can’t use my data source from my gateway in Service

I can’t use my data source from my gateway

Guylyan — Thu, 07 Dec 2023 20:49:39 GMT

I published some reports in my workspace that use a connection to SQL Server, which I can use normally on the desktop. However, when I publish I cannot use my gateway connection to perform automatic updates.

When I click on "Add to Gateway" and fill in the following error occurs:

I've checked my details several times, they're all correct, from IP to login.

Re: I can’t use my data source from my gateway

Anonymous — Fri, 08 Dec 2023 09:45:35 GMT

HI Guylyan ，

Based on the picture you provided, you have encountered error code 25. This error message is commonly displayed when there is a problem with the connection to the SQL Server. The error message indicates that the server was not found or was not accessible.

To troubleshoot this issue, you can try the following steps:

Verify that you have permission to access the server and database.
Check if the SQL Server is configured to allow remote connections.

I hope my solution can help you, but if it doesn’t, you can always share your thoughts and feedback with me by posting a comment below this post.

In order for you to solve the problem faster, you can refer to the following documentation

How to Get Your Question Answered Quickly - Microsoft Fabric Community

Best Regards,

Albert He

Re: I can’t use my data source from my gateway

Guylyan — Fri, 08 Dec 2023 12:39:05 GMT

I didn't understand exactly about checking the SQL, but I can make a connection to my gateway with the DB

I just tried to reinstall the gateway, changing the name, but without success yet

Error 25 occurs when I click "add to gateway"

Re: I can’t use my data source from my gateway

aj1973 — Sat, 09 Dec 2023 15:55:30 GMT

Hi Guylyan

Before worrying about connecting to SQL you need to configure your gateway. The message is clear, the status of your gateway is not configured correctly.

Re: I can’t use my data source from my gateway

Guylyan — Mon, 11 Dec 2023 11:04:17 GMT

What did I do wrong?
My gateway appears to work.

Re: I can’t use my data source from my gateway

aj1973 — Mon, 11 Dec 2023 13:13:57 GMT

It is in the service that your Gateway is not configured

Is it a personnal Gateway? Is your Tenant Admin allowing it? In the service, were you added as a User to the Gateway?

Re: I can’t use my data source from my gateway

Guylyan — Tue, 12 Dec 2023 17:28:30 GMT

I solved the problem!

To solve this problem, i create a data connection by skipping the authentication and select it from the dataset, after that we create another connection with the login data and then switch in the dataset again.

I contacted support and was unsuccessful, but after continuing to try, I found a way for it to work. But it's a PowerBI bug.