Forum Discussion

amt1907's avatar
amt1907
New Member
10 months ago
Solved

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...
admin
Real-Time hub
workspaces
  • amt1907's avatar
    amt1907
    9 months ago
    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!
v-hjannapu's avatar
v-hjannapu
Community Support
9 months ago

Hi 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.

FabScone75's avatar
FabScone75
Helper I
9 months ago

I am experiencing a very similar issue. I created a lakehouse and a warehouse. I am now unable to move data from the Lakehouse to the Warehouse! My error is:

Couldn't refresh the entity because of an issue with the mashup document MashupException.Error: DataSource.Error: Microsoft SQL: Internal system error (0xa(MWC service error: Server responded with error: 400)(AdalRetryException: There is a problem with the Microsoft Entra ID token. Have the warehouse owner log in again. If they're unavailable, use the takeover feature.)) when attempting to open or create remotely stored delta log file. This error is usually intermittent. Please try the operation again and contact Customer Support Services if this persists.

I have had an open support ticket for 2 weeks without resolution.