Forum Discussion

Sam_'s avatar
Sam_
Frequent Visitor
1 year ago
Solved

VNET data gateway cannot write to lakehouse

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...
Need Help
Pipeline
  • v-ssriganesh's avatar
    v-ssriganesh
    1 year ago

    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's avatar
v-ssriganesh
Community Support
1 year ago

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.