Cannot change cloud connection

Question

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?

markwojo1 · Answer

GilbertQ&nbsp;thanks for the thoughts on this.&nbsp; I was hoping to move in a direction where more than one user could maintain a dataset.&nbsp; 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.&nbsp;&nbsp;

gilbertq · Answer

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

gilbertq · Answer

Hi&nbsp;MarkWojo1&nbsp;
&nbsp;
I would then suggest creating a gateway connection, which can then be shared with multiple users, instead of a cloud connection?
&nbsp;
Also someone will have to take over the dataset once you leave.

markwojo1 · Answer

GilbertQ&nbsp;it's a fair suggestion to use a gateway, but I'm not looking for a work around.&nbsp; I'm wondering if I have something wrong with permissions or otherwise that I can't use the cloud connection that I created.&nbsp; The gateway will add cost and, as you noted, won't allow more than one user to configure -- they have to take it over.&nbsp; 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?

amélie · Answer

Hello,&nbsp;&nbsp;Do you find a way to see your connection ?&nbsp;&nbsp;I have the same issue with a report. I publish the same report in a workspace, with the same connection. For one report I can use the connection that i've created :&nbsp;&nbsp;but for the other report i can't see the connection :&nbsp;&nbsp;It's exacly same connection on this two report.Is it a permission problem or just a bug ?&nbsp;

Forum Discussion

Cannot change cloud connection

6 Replies

Related content

Change Source Connection on Mirrored Database

Destination Connection dropdown changed

How to change lakehouse connected to semantic model? Programmatical Approach

Changing the source connection info

Connection failed using a Folder connection in a pipeline