Gateway not working correctly

[reymalave]

Hi guys, 

      Today I was trying to configure a schedule refresh for a data set with my on-premises gateway. To my surprise the gateway connection is "not configured correctly". Taking a closer look at the problem I find out is trying to reach a nonexisting DB, is calling just the server as shown in the picture below. I try adding this nameless database to the gateway and it doesn´t work. I also tried to erase the gateway and configuring it again but it shows the same problem. Below you´ll find both the screen with the main error and the error itself. Can someone please help me out?

Thanks, 

Reynaldo

[GilbertQ]

Hi there

When you create a data source you need to make sure that both the server and database can be contacted with the credentials and verified.

You should then select the option from the drop down to get it working?

[reymalave]

Hi,

Thanks for your answer, unfortunately it does not address the issue I described. Connection and credentials are verified and connected except for this nameless database that i dont know where it comes fron

[GilbertQ]

Hi there

When you say nameless database what do you mean by that?

A database name that does not exist?

[reymalave]

Hi @GilbertQ,

Take a look at the first image. It has a green checkmark and is connected to the server and the db then it has a red X with the same address pointing to a "" (nameless or blank ) database. This is the issue I dont really know why is this connection here and can not erase it.

Thanks,

Reynaldo

[kcantor]

@reymalave 

Check in your data model in your pbix file. You may have accidentally created  an erroneous connection. If you remove the connection(attempt) from the model, the gateway will not try to connect to it. Those connections appear because the model tells the service that the connection should exist.

[reymalave]

Hi @kcantor ,

Thanks for your reply, I did check the file but did not find anything wrong with it. Can pinpoint where do you think this connection may be? A place I should be checking? 

Thanks,

Reynaldo

[kcantor]

Check in query editor as the source may not be set to load and thus may not appear in the datamodel.

You can open query editor in your data model, expand out the query pane on the left side. If you see it there, great! Delete it and you are done. If you do not see it there, you will need to check each query in your model either by clicking into the advanced editor or the gear by the first step in the query where the source is connected to. One of those should have your misbehaving connection.

You are receiving this error because your data model is telling your gateway that this connection exists somewhere within the model. 

[reymalave]

Hi @kcantor  @GilbertQ ,

Thanks for your responses. The first thing I did was to check the query and could not find anything. I elevated this issue to customer support. They will be remotely conecting to my computer to see what is actually going on.

[kcantor]

@reymalave 

Microsoft is very helpful once a ticket is filed. Good luck. Also, please stop back by and post the solution here if you have time. Perhaps your solution will help others in the future.

[GilbertQ]

Hi there

If you go into the data sources, is it possible that you created to data sources too the same database?

Possibly delete the one that you do not need?

[reymalave]

Hi @giobertq,

Take a look at the first image. It has a green checkmark and is connected to the server and the db then it has a red X with the same address pointing to a "" (nameless or blank ) database. This is the issue I dont really know why is this connection here and can not erase it.

Thanks,

Reynaldo