topic How to make the service principle the owner of power bi dataset to update the parameter using API in Data Engineering

How to make the service principle the owner of power bi dataset to update the parameter using API

Anonymous — Wed, 30 Oct 2024 18:04:38 GMT

I have a power bi dataset in my fabric workspace and I need to update the parameter in that using update parameter API using service principle.And then need to refresh the dataset from notebook .But when I tried that I got a message that "only dataset owner can edit the dataset".How to make service principle as the owner of the dataset inorder to make this request or what are the permissions required to implement this from a note book?

I have used the following API Call:

POST https://api.powerbi.com/v1.0/myorg/groups/{groupId}/datasets/{datasetId}/Default.UpdateParameters

Re: How to make the service principle the owner of power bi dataset to update the parameter using A

tackytechtom — Wed, 30 Oct 2024 21:21:44 GMT

Hi @Anonymous,

There is a takeOver API call:

POST https://api.powerbi.com/v1.0/myorg/groups/{groupId}/datasets/{datasetId}/Default.TakeOver

Datasets - Take Over In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn

Here an article that uses this as part of a Powershell script:

https://www.tackytech.blog/how-to-make-a-service-principal-the-owner-of-a-power-bi-dataset/

Of course, you could fire this API from a Python script, too.

Let me know if this helps 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

@Anonymous