How to add cloud connection and bind it after to dataset programatically/via rest API

[jaryszek]

Hi Guys,

I want to add cloud connection (to the blob storage)  to the power bi service and as next step i want to bind it with currect existing dataset.

How to do this programatically? 

Current solution which I found are related with connecting to on-promises data source (existing ones). 
https://www.youtube.com/watch?v=lfP6ygindSU&list=PLpBU4EcPajILyeFik6p9EedYoUH4kh12m&index=8 

Best,
Jacek

[ibarrau · Accepted solution]

Hi. The bind is only for Gateway. After you configure a gateway and a source you can set a source to the dataset. But, if you are connecting to cloud sources that's not an option. The most similar thing I have seen at the Fabric Rest API (it's kind of new), it's updating connection. It let's you change the connection and credentials of a dataset. I'm not sure how the body is built, it's really new and I haven't tried it yet. You can read about it here: https://learn.microsoft.com/en-us/rest/api/fabric/core/connections/update-connection?tabs=HTTP

I don't think there is another way.

I hope that helps,