Connecting power bi to azure sql database using private endpoint

[zelalakyol]

 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-using-private-endpoints/

At first, the connection was successful, but an error appeared that a license was required to refresh the dataset. When I checked the document, I saw that it was because I did not have the appropriate license. Then, when I tried to test and refresh the connection again, I received the following errors. How can I solve this problem and provide a secure sql connection with a private endpoint?

  

[GilbertQ]

Hi @zelalakyol 

To me it looks like a connectivity issue you might need to look into?

[zelalakyol]

Hi @GilbertQ 

Actually nothing has changed since the connection was successfully created. But now we are encountering this error

[hgb-dmi · Accepted solution]

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):

https://learn.microsoft.com/en-us/data-integration/vnet/create-data-gateways#step-2-associate-the-su...

 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.

[zelalakyol]

Thank you!