Forum Discussion
Datawarehouse owner change
- 1 year ago
Hello BenLyon
If you haven't visited, please go through this Change Ownership of Fabric Warehouse - Microsoft Fabric | Microsoft Learn documentation. It might helps you!
Thank you!!
- Anonymous1 year ago
Hello BenLyon ,
Thanks for reaching out to the Microsoft fabric community forum.
Yes, it is possible to change the owner of a data warehouse in Microsoft Fabric. This can be done using Power BI PowerShell commands provided by Microsoft. The ownership transfer is handled through a "takeover" process, which allows a user with sufficient permissions (such as Administrator, Member, or Contributor in the workspace) to assume ownership of the data warehouse.
To perform the takeover, you will need to install the Power BI PowerShell module, connect to the Power BI service, and run a specific REST API call using the workspace and warehouse IDs. These IDs can be obtained directly from the URL of the warehouse when opened in the SQL editor. After executing the takeover command, the signed-in user becomes the new owner of the warehouse.
Please note that this method only applies to the Fabric data warehouse and not to other artifacts like the SQL analytics endpoint.
For step-by-step instructions, you may refer to the official Microsoft documentation here which is already provided by suparnababu8 :
Change Ownership of Fabric Warehouse - Microsoft Fabric | Microsoft Learn
I hope this will resolve your issue, if you need any further assistance, feel free to reach out.
If this post helps, then please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.
Thankyou.
Hi @BenLyon ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.