Forum Discussion
Microsoft Entra ID Error
- SOLUTION: Go to Microsoft Fabric > One Lake Catalog > Select Workspace > Select Type as Lakehouse and Warehouse> Search Staging > Now Open the files for which you are not the owner then in the URL https://app.powerbi.com/groups/eWORKSPACE ID/lakehouses/LAKEHOUSE or WAREHOUSE ID?experience=power-bi. Now Open Power Shell as Administrator and run this: Install-Module -Name MicrosoftPowerBIMgmt Import-Module MicrosoftPowerBIMgmt Import-Module MicrosoftPowerBIMgmt Install-Module -Name MicrosoftPowerBIMgmt Connect-PowerBIServiceAccount $workspaceID = '' $warehouseid = '' #Invoke warehouse takeover $url = 'groups/' + $workspaceID + '/datawarehouses/' + $warehouseid + '/takeover' Invoke-PowerBIRestMethod -Url $url -Method Post -Body "" (After this double Click) Now you have became the owner of that lakehouse or warehouse. Do this for all the other staging files for which you are not the owner. IF still it not works, then raise a microsof ticket and connect with customer support agent., Thanks!
Hi amt1907,
The owner of the lakehouse left or changes its permissions, it may cause the problem.
1) Re-authenticate the Lakehouse SQL endpoint
Go to the Lakehouse in the Fabric workspace.
In the ribbon, open the “SQL endpoint” view.
Click “Manage permissions” or “Take ownership” (if available).
Once you’ve taken ownership, refresh the page and try the publish operation again.
2) Confirm you have the correct Lakehouse role and there is not restriction on the security roles on lakehouse
Open the Lakehouse → Settings → Permissions
Ensure your account (or the service principal you’re using) has “Lakehouse Admin” or “Contributor” role — not just Workspace Admin.
Hope it can help you !
Best regards,
Antoine
Open the Lakehouse → Settings → Permissions
I don't see these permissions option on my lakehouse settings button.