Cannot change cloud connection

[MarkWojo1]

I have uploaded a new report to the service.  I tried configuring the connection to the data source ->

• Gateway and cloud connections
  • Cloud connections
    • Maps to -this is set to `Personal Cloud Connection`, but also has the option to `Create a new connection`.  I am able to create the new connection successfully, but I cannot select it in the dropdown.  I do see that it is created under `Manage connections and gateways`

Is there some special permission needed for this?

[GilbertQ]

Hi @MarkWojo1 

I have typically found just to use the personal connection works best to make sure that the datasets can refresh successfully.

[MarkWojo1]

@GilbertQ thanks for the thoughts on this.  I was hoping to move in a direction where more than one user could maintain a dataset.  There's two issues that I have with the personal connection - one, I cannot edit the server or database, it's greyed out and, two, I'm a contractor and I do not want to leave behind connections that someone needs to reconfigure when my job is done.  

[GilbertQ]

Hi @MarkWojo1 

I would then suggest creating a gateway connection, which can then be shared with multiple users, instead of a cloud connection?

Also someone will have to take over the dataset once you leave.

[MarkWojo1]

@GilbertQ it's a fair suggestion to use a gateway, but I'm not looking for a work around.  I'm wondering if I have something wrong with permissions or otherwise that I can't use the cloud connection that I created.  The gateway will add cost and, as you noted, won't allow more than one user to configure -- they have to take it over.  Because our data sources are all azure services, it makes a lot of sense for us to use this feature, but what's the secret incantation to make it work?