Forum Discussion

connor55's avatar
connor55
New Member
5 years ago
Solved

Merge query connection issue

Hey everyone!  

Every time I try to merge a query that uses a different source that the parent query, I get a connection error.  I'm not sure how to fix this, any help would be amazing!

 

I'm able to merge t

  • connor55's avatar
    connor55
    5 years ago

    Anonymous I was looking for that setting you just shared when I stumbled across the setting below under 'Options'.  Allow multiple data sources was unchecked!  Everything is working fine now.  Thanks everybody!

7 Replies

  • Hi connor55 

    Have you clicked on the 'Configure Connection' button (top right of your image) and entered info to make the connection?

    Phil 


    If I answered your question please mark my post as the solution.

    If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.

    • connor55's avatar
      connor55
      New Member

      Hey PhilipTreacy thanks for the response!

      I have tried that, but I think I'm doing somthing wrong?  I selected the existing connection & it brought me back to the same configure connection pop up.  I then tried to create a new connection, and the same thing happened.

      • Anonymous's avatar
        Anonymous
        Not applicable

        Hi connor55 ,

         

        I think you need to do it for every connection you use. But the connection is defined quite vaguely here: multiple sources from the same web-domain should not require confirming a new connection. But, I believe, for two different domains it will ask you to connect twice. However, once you've connected, it should not ask you to do it again (for the same data source). Unless you using some weird form of anonymiser/firewall.

         

        Kind regards,

        JB