Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Join the FabCon + SQLCon recap series. Up next: Power BI, Real-Time Intelligence, IQ and AI, and Data Factory take center stage. All sessions are available on-demand after the live show. Register now

marcosdp

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

Submitted by on ‎08-14-2022 05:07 PM

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 could access Azure SQL Server on Power BI DataFlow creation with no issues. However, after saving data flow creation and confim first execution, system displayed "Execution for On-Prem data source failed because it's not registered on a gateway (218884)" message.

 

Could someone help me to identify the solution for that issue?

Status: Investigating

Hi @marcosdp,

 

If you directly register your Azure SQL data source to your VNet gateway, will you see any error? Please create and save your dataflow after you register successfully there.

 

Best Regards,    

Community Support Team _ Caiyun

See more ideas labeled with:
6 Comments (6 New)
Comments
v-cazheng-msft
Community Support
Community Support
‎08-16-2022 12:50 AM
Status changed to: Investigating

Hi @marcosdp,

 

If you directly register your Azure SQL data source to your VNet gateway, will you see any error? Please create and save your dataflow after you register successfully there.

 

Best Regards,    

Community Support Team _ Caiyun

marcosdp
Regular Visitor
‎08-16-2022 07:53 AM

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.

marcosdp_0-1660655954702.png

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.

marcosdp_1-1660660556369.png

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

marcosdp_2-1660660764248.png

marcosdp_3-1660660834140.png

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

marcosdp_4-1660660864505.png

 

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

marcosdp_5-1660661060482.png

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

marcosdp_0-1660661788274.png

 

 

Any idea?

 

Best Regards

 

 

lewisholmes
Regular Visitor
‎10-13-2022 08:17 AM

I've just had exactly the same problem. Did you find a resolution?

marcosdp
Regular Visitor
‎10-13-2022 08:57 AM

Hi, @lewisholmes 

Unfortunately not. I think there is a bug on that power bi feature.

rwars
New Member
‎03-03-2023 02:56 PM

I have the exact same issue, and it's making it very annoying to maintain database-loaded datasets though a vnet gateway.  Will let you know if I find a resolution.

aksmith
New Member
‎05-16-2023 10:07 PM

We are having the same issue also - anyone know if there is a fix?

Idea Statuses