Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
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.
Proud to be a Super User!
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
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.
Proud to be a Super User!
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.
Proud to be a Super User!