Update datasource credential using API with Cloud connection

Question

I am working on automatically update token when the token expires. I was able to update the credentials that is using gateway connection. I am doing now to update the credential that is using cloud connection but having an error for Unauthorized access with the gateway.

I was able to view gatewayID and DatasourceID with Cloud connection. Question is where are the gateways with cloud connection? How the permission managed with those gateway in cloud connections?

I never had any issues if using gateway connections as I can manage the gateway permissions under on-premise data gateway the only issue is with the cloud connections.

anonymous · Answer

Hi rdlhrvy ，
As far as I know, gateways are just local data gateways and personal gateways, vnet gateways. Cloud connections are connections to the appropriate cloud data sources and are not strictly gateway types.

&nbsp;
&nbsp;

&nbsp;
If you have any other questions, here's the file I found for you, hope it helps.
On-premises data gateway - Power BI | Microsoft Learn
&nbsp;
Hope it helps!
&nbsp;
Best regards,Community Support Team_ Tom Shen
&nbsp;
If this post helps then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly.
&nbsp;
&nbsp;
&nbsp;
&nbsp;

rdlhrvy · Answer

What I am trying to do is that update the credential using API that is created with Shareable Cloud Connection. Databricks Access Token expires every 30 days so it makes a lot of sense to schedule a notebook job to update the access token without manually changing it in Power BI connection.

I have another connection as well that is created with On-premise and I can execute my notebook successfully with updating credential.

The challenge I have right now is updating the credential that is created with Sharable Cloud Connection.

I can get the datasourceId and gatewayId as that is needed to update the credential

When I try executing this API I am getting a response of PowerBINotAuthorized

Now my question is where is that gateway that is used with Cloud Connection? It shows there is a gateway but where is that and how to provide permission so that I can execute that API? That is only missing piece to successfuly execute the notebook. Just permission with the gateway.

Even with Personal Cloud Connection will have gateway returned if you call the API it will show datasourceId and gatewayId

saitejatalasila · Answer

Hi rdlhrvy&nbsp;,
&nbsp;
Go to manageconnections and gateways in power bi service and check whether that connection is still available or not.
&nbsp;
Thanks,
Sai Teja&nbsp;

rdlhrvy · Answer

The shared cloud connection that was created is there. I can even use that connection to any dataset published that used the same connection.&nbsp;&nbsp;It is only updating the credential for that connection is the issue using API. I can update manually but not with API

saitejatalasila · Answer

Hi rdlhrvy&nbsp;,
&nbsp;
You can check with your tenant admin once if he is unable to find it then you can open a ticket with MS support.
&nbsp;
I think the rest API command which you are trying to use only works with&nbsp; gateway connections and not for cloud connections.
&nbsp;
Thanks,
Sai Teja&nbsp;

Forum Discussion

Update datasource credential using API with Cloud connection

7 Replies

Related content

Invalid Connection Credentials

Service principal for dataset datasource credential

Unable to update connection credentials. Invalid connection credentials.

Invalid Credentials - Snowflake Connection

Sharepoint connection credential expiring