Getting error that my gateway is "not configured correctly"

[DorienM]

Hi All,

I have an on-prem data gateway that connects to two different on-prem sql services. I just published a report that uses the second sql service, it connects with basic auth. I need to set up its connection to my data gateway so I can configure the report to refresh on a schedule. 

When I go to set up the gateway on my dataset I see the message "not configured correctly" shown here:

I then click on "Add to gateway" and add the data source. In the Server field I need to change servername:12345 to servername,12345 or I notice it wont connect, I set authentication to use basic auth and add in the username and password then click add. The connection tests successfully. Unfortunately when I go back to the dataset to connect it to the gateway I still see the error "Not configured correctly" and the details are exactly the same as before despite adding the datasource to my gateway and testing it correctly.

I have already tried to solve this issue myself including trying everything described in this thread:

Re: gateway "not configured correctly" - Microsoft Power BI Community

Unfortunately no luck, can anyone here help out?

[lbendlin]

scroll further down and update your data source credentials.  Seems unrelated but it isn't.  All part of the recent gateway wobbles. 

[DorienM]

Unfortunately the "Data Source Credentials" section is created out and inaccessible because I can't select a gateway in the first place.

 

[lbendlin]

Go back to your Power BI Desktop and change the server address to server,port instead of server:port . Then re-publish.

[DorienM]

I already did that as well as I described in my original post. I actually can't even test the connection if I leave it as servername:port

[lbendlin]

We have seen cases where a difference in spelling between desktop and gateway can create issues too. Can you please validate that the connection strings match exactly?  Including letter case.

[DorienM]

No dice here either, I verified the connection strings match exactly right down to the case. I don't suppose this has to do with the authentication method? On PBI desktop I select database authentication whereas in PBI service I need to select Basic authentication because database authentication is not an option, I assume this is fine because the connection tests successfully on the gateway config side of things but of course it still does not appear to work for connecting the dataset to the gateway.