VNET data gateway cannot write to lakehouse

[Sam_]

I have come accros an issue that wont allow me to write data to a lakehouse in a copy activity that utilises a VNET data gateway. The error messages references lakehouse Internal Server Error. 

I can successfully preview my data from my VNET data gateway source and as the error suggests the issue is associated with writing to the destination lakehouse. Please help, has anyone been able to successfully use VNET data gateways to land data to a lakehouse?

ErrorCode=LakehouseOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Lakehouse operation failed for: Operation returned an invalid status code 'InternalServerError'.  Message: 'Internal Server Error'. TimeStamp: 'Thu, 24 Apr 2025 10:13:16 GMT'..,Source=Microsoft.DataTransfer.ClientLibrary,''Type=Microsoft.Azure.Storage.Data.Models.ErrorSchemaException,Message=Operation returned an invalid status code 'InternalServerError',Source=Microsoft.DataTransfer.ClientLibrary,'

[v-ssriganesh]

Hi @Sam_,

May I ask if you have resolved this issue? If so, please mark it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[Sam_]

Hey,

unfortunately not the issue still perists

Thanks,

Sam

[schilling]

Just resolved a similar issue. 

added service endpoint of microsoft.storage in the delegated gateway subnet in spoke vnet, that solved the issue. We had UDR 0/0 in the vnet gateway subnet pointing back to security appliance in hub vnet and subsequently routed back to on-prem for Internet access. . 

https://learn.microsoft.com/en-us/data-integration/vnet/data-gateway-architecture is not accurate, especially 

The VNet gateway doesn't require any Service Endpoint or open ports back to Power BI. Data from the VNet is returned to Power BI by an internal Microsoft tunnel that doesn't reach the public internet, which uses Automatic Private IP Addressing (APIPA) and exists on the infrastructure virtual machine.

We did firewall log analysis, and noticed that the https://learn.microsoft.com/en-us/data-integration/vnet/troubleshoot-data-gateway traffic is going through on-prem Internet, even after we punched temporary firewall holes, the write still not success with error message like:

Lakehouse operation failed for: Operation returned an invalid status code 'InternalServerError'.

Source=Microsoft.DataTransfer.ClientLibrary,
''Type=Microsoft.Azure.Storage.Data.Models.ErrorSchemaEx

So on the delegated vnet, we added microsoft.storage service endpoint, then subsequent write is successful. 

[v-ssriganesh · Accepted solution]

Hi @Sam_,

Please consider raising a Microsoft support ticket. You can provide them with all the troubleshooting steps you've already taken, which will help them understand the issue better and provide a resolution. They might be able to identify something specific about your issue or provide a solution that isn't immediately obvious. 

Below is the link to create Microsoft Support ticket:
How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

If this helps, please consider marking it 'Accept as Solution' so others with similar queries may find it more easily. If not, please share the details.
Thank you.

[v-ssriganesh]

Hi @Sam_,

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.

Thank you for your understanding and assistance.

[Sam_]

Hi @v-ssriganesh 

Unfortunately the issue still persists, a support ticket has been created and has been actively worked on for 2 weeks

Thanks,

Sam

[v-ssriganesh]

Hi @Sam_,

We greatly appreciate your efforts and thank you for providing the update on the issue. If the issue has been resolved, kindly share the insights, as this will assist other community members in resolving similar issues more efficiently.

Thank you.

[v-ssriganesh]

Hi @Sam_,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.

[v-ssriganesh]

Hello @Sam_,

Thank you for reaching out to the Microsoft Fabric Community Forum. Based on the information provided, here are some insights and potential troubleshooting steps:

• Check the VNET data gateway and the lakehouse are in the same region, as the gateway can only be accessed from your tenant's home region.
• When using a virtual network data gateway and a private endpoint to connect to a data source, you might experience occasional TCP connection issues. This is a known problem and will be resolved in future updates.
• VNET data gateways currently support only admin roles and not "Can Use and Can Use+Share" for Power Platform dataflows.
• Check for any network connectivity issues between the VNET data gateway and the lakehouse.
• Make sure the VNET data gateway is properly configured and that the necessary roles and permissions are assigned.

For your reference: https://learn.microsoft.com/en-us/data-integration/vnet/overview#limitations

If possible, test the VNET data gateway with different data sources to identify if the issue is specific to the lakehouse or a broader problem with the gateway.

If this information is helpful, please “Accept as solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.