Forum Discussion

sovereignauto's avatar
sovereignauto
Helper III
4 years ago

Multiple Sources Dataflow (Dataverse and On Prem Gateway)

Good Evening,

 

Im trying to connect my gateway that works perfect for our on prem SQL but im now trying to add a dataverse connection which is trying to use the same gateway and if remove the gateway from the dataverse connection it looses it from the SQL connection.

 

Is it not possible to do this? 

If i leave the gateway in place it wants me to connect using my organisation account where as the SQL i connect using windows account and if i do use organisation account i then get this message:

 

Unable to create an OAuth connection. Reason: "Only admins of an on-premise data gateway can create connections. To use this connection, switch to an on-premise data gateway that you are an admin of, or ask your on-premise data gateway admin to add you as a user of this connection. (Session ID: e99938bc-84eb-415d-a3eb-3951a37be016, Region: europe)"

Do i need to "pass through" the gateway and if so what do i need to ask my admin to add to the Gateway to use it?

Thank you!

 

 

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi sovereignauto ,

     

    When you install a gateway, you are by default an admin of that gateway. You then add additional users or security groups as admins by using the Administrators tab for the gateway. You also use this tab to remove admins.

    Hope it helps,


    Community Support Team _ Caitlyn

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.