The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Solved! Go to Solution.
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
Did I answer your question❓➡️ Please, mark my post as a solution ✔️ |
Also happily accepting Kudos 🙂 |
Feel free to connect with me on LinkedIn! | |
#proudtobeasuperuser | |
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
Did I answer your question❓➡️ Please, mark my post as a solution ✔️ |
Also happily accepting Kudos 🙂 |
Feel free to connect with me on LinkedIn! | |
#proudtobeasuperuser | |