Forum Discussion
Solved
Connecting power bi to azure sql database using private endpoint
Hello, we want to connect to private Azure SQL via virtual network. For this, I followed all the steps in the document below. https://www.serverlesssql.com/connecting-power-bi-to-azure-sql-database-...
FYI - I noticed in the referenced serverlesssql article that the poster shows creating the PowerPlatform delegated subnet with address range 10.0.1.0/24. However, the official Microsoft documentation notes to make sure the subnet address space does not overlap with 10.0.1.x (which is another way of writing 10.0.1.0/24):
Note
- Don't use the subnet name "gatewaysubnet" as this is a reserved word for the Azure Gateway Subnet feature. You won't be able to use it to create a VNet data gateway in Step 3.
- Make sure this subnet doesn't have an IPV6 address space added.
- Make sure the subnet's IP range doesn't overlap with 10.0.1.x.
FYI - I noticed in the referenced serverlesssql article that the poster shows creating the PowerPlatform delegated subnet with address range 10.0.1.0/24. However, the official Microsoft documentation notes to make sure the subnet address space does not overlap with 10.0.1.x (which is another way of writing 10.0.1.0/24):
Note
- Don't use the subnet name "gatewaysubnet" as this is a reserved word for the Azure Gateway Subnet feature. You won't be able to use it to create a VNet data gateway in Step 3.
- Make sure this subnet doesn't have an IPV6 address space added.
- Make sure the subnet's IP range doesn't overlap with 10.0.1.x.
Thank you!