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!
v-hjannapu
Community Support
10 months agoHi amt1907,
Could you please confirm if the issue has been resolved after raising a support case? If a solution has been found, it would be greatly appreciated if you could share your insights with the community. This would be helpful for other members who may encounter similar issues.
Regards,
Community Support Team.
amt1907
9 months agoNew Member
YES i provided the solution in comments. Plz check.