marcosdp's avatar
marcosdp
Regular Visitor
4 years ago
Status:
Investigating

Issues on connection between Power BI and Azure SQL Database using VNet service endpoints

Hi, I'm facing an issue on trying to connect Power BI to Azure SQL Server with Private endpoint activate and public access disable. After creating an virtual network gateway on Power Platform I coul...
Gateways
marcosdp's avatar
marcosdp
Regular Visitor
4 years ago

Hi v-cazheng-msft,

 

I've followed all the steps related to this documentation https://www.datahai.co.uk/power-bi/connecting-power-bi-to-azure-sql-database-using-private-endpoints/ 

 

1. Look at bellow that Virtual Network data gateway is online.

2. At the first moment, I can access sql server table with no issues. I'm not sure the reason that Data Gateway option on Project Options has no content to select.

3. The problem starts when I click on Refresh now.

Execution fails with "Error: Execution for On-Prem data source failed because it's not registered on a gateway (218884). Additional details: . Param1 = 218884.Param2 = Request ID: xxxx" message

 

4. When I edit data flow again, systems ask for credentials as lost it.

So, I inform credentials again just to return to the same point as step 2

 

 

Any idea?

 

Best Regards

 

 

Completed Ideas