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!
FabScone75's avatar
FabScone75
Helper I
9 months ago

Hello, I wanted to update this issue with a potential solution. We had a scenario where we had a staging warehouse that was created that was owned by someone who had left the organisation. I had to find the warehouse and take ownership. 

The error message I had was:

dimactivities: Error Code: Mashup Exception Data Source Error, Error Details: 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. Statement ID: {xxxxxxxxxxxxxxxx} Details: Reason = DataSource.Error;ErrorCode = 10478;DataSourceKind = Lakehouse;DataSourcePath = LakehouseModelStorage;DataSourceKind.2 = SQL;DataSourcePath.2 =xxxxxxxxxxxxxxxxxxxx.datawarehouse.fabric.microsoft.com;StagingWarehouseForDataflows_20250904084952;Message = 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. 

 

You will see the bold part above which references the staging warehouse. I had to find this warehouse, and once I found it, take ownership. Once I owned the warehouse, I found that my dataflow ran without the error. 

For guidance on taking ownership, see here:
Change Ownership of a Warehouse - Microsoft Fabric | Microsoft Learn

amt1907's avatar
amt1907
New Member
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!