Forum Discussion
VNET data gateway cannot write to lakehouse
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 LearnIf 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.
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.
Hey,
unfortunately not the issue still perists
Thanks,
Sam
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 LearnIf 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.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.
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.ErrorSchemaExSo on the delegated vnet, we added microsoft.storage service endpoint, then subsequent write is successful.
