Forum Discussion
Gateway not working correctly
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
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.
- reymalave7 years agoHelper I
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
- GilbertQ7 years agoSuper UserHi 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? - kcantor7 years agoCommunity Champion
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.