Forum Discussion
amt1907
10 months agoNew Member
Microsoft Entra ID Error
Getting this error while Publishing the data on lakehouse. Already taken over the lakehouse, workflows. still getting this error: Unable to create a table on the Lakehouse SQL catalog due to metadat...
- 9 months agoSOLUTION: 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!
amt1907
10 months agoNew Member
Still not working. There is no changes...till 22nd oct its working but after that not working.
Anonymous
10 months agoNot applicable
Hi amt1907,
If you are still unable to solve the issue you can reach out to Microsoft Support by raising a ticket with Microsoft Support.
Please refer below link on how to raise a contact support or support ticket.
How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn
Regards,
Community Support Team.