Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
TonyCampney
New Member

On-Premises Data Gateway with PowerBI Private EndPoint

We have setup access to PowerBI over a Private EndPoint as described here (Private endpoints for accessing Power BI - Power BI | Microsoft Docs).  Within that same environment we are now trying to setup an on-premises data gateway.  We have allowed all traffic from the gateway VM to the public endpoints as described here Adjust communication settings for the on-premises data gateway | Microsoft Docs and also are allowing all traffic from the gateway VM to the Powrer BI Private EndPoints.  When trying to configure the data gateway, I'm getting the below error.  Reviewing the issue via firewall and wireshark connectivity doesn't seem to be an issue, but traffic like below to https://fec8632f0bd64e3a9761866aef52dd57-api.analysis.windows.net/ is being routed to the Private EndPoint (but from wireshark there does seem to be successful communciation to the Private EndPoint).

 

Anyone have any ideas?  Is it possible On-Premises Data Gateway and PowerBI Private EndPoints cannot co-exist?

 

EnterpriseGatewayConfigurator.exe Information: 0 : Create gateway pbi-gtwy-pcc-vm, https://fec8632f0bd64e3a9761866aef52dd57-api.analysis.windows.net/
EnterpriseGatewayConfigurator.exe Information: 0 : Update local gateway config
EnterpriseGatewayConfigurator.exe Error: 0 : Exception: Microsoft.PowerBI.DataMovement.GatewayCommon.FailedToUpdateGatewayException: Failed to update gateway details. You may need to change the account the gateway runs under. ---> System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.PowerBI.DataMovement.GatewayCommon.DmtsGatewayCreation.UpdateGatewayConfiguration(CreateGatewayResponse createResponse, SecureString recoveryKey, String salt, SecureString legacyRecoveryKey, String legacySalt, Uri backendUri, String containerName, Boolean copyKeyAsLegacy, GatewayServiceBusDetails listenerDetails, Int32 maxRetries)
--- End of inner exception stack trace ---
at Microsoft.PowerBI.DataMovement.GatewayCommon.DmtsGatewayCreation.UpdateGatewayConfiguration(CreateGatewayResponse createResponse, SecureString recoveryKey, String salt, SecureString legacyRecoveryKey, String legacySalt, Uri backendUri, String containerName, Boolean copyKeyAsLegacy, GatewayServiceBusDetails listenerDetails, Int32 maxRetries)
at Microsoft.PowerBI.DataMovement.GatewayCommon.DmtsGatewayCreation.CreateAndUpdateLocalService(String gatewayName, SecureString recoveryKey, String salt, Uri dmtsBackendUri, GatewayServiceBusDetails senderDetails, GatewayServiceBusDetails listenerDetails)
at Microsoft.PowerBI.DataMovement.EnterpriseGatewayConfigurator.WizardServiceConfigurationViewModel.ValidateAndCreateGateway(String gatewayName, SecureString recoveryKey, SecureString legacyRecoveryKey)
at Microsoft.PowerBI.DataMovement.EnterpriseGatewayConfigurator.WizardServiceConfigurationViewModel.DoOk(Object param)
at Microsoft.PowerBI.DataMovement.GatewayUiCommon.WizardViewModelBase.DoOkWorker(Object param)
at Microsoft.PowerBI.DataMovement.GatewayUiCommon.RelayCommand.<>c__DisplayClass19_0.<Execute>b__0()

1 ACCEPTED SOLUTION

Did you go through all this?

https://docs.microsoft.com/en-us/power-bi/admin/power-bi-allow-list-urls

 

And then there's this:

  • Gateways enabled for Power BI private endpoints will not work properly with non-Power BI scenarios. A potential workaround is to turn off Private Links, config the gateway, and then reenable the Private Links.

View solution in original post

6 REPLIES 6
lbendlin
Super User
Super User

Any proxies required in your network setup?

No proxies.  If it matters, this is a VM in Azure and the PowerBI endpoint is in the same vNET as the gateway VM.  All non-end Point (public) traffic is routed out through a Fortigate NVA (firewall).

Can you log in to https://app.powerbi.com from the gateway VMs ?

Yes, that works fine but as you can see from the below screenshot that address is resolving to our private endpoint as I'd expect with the private endpoint setup.

TonyCampney_0-1640693731679.png

 

Did you go through all this?

https://docs.microsoft.com/en-us/power-bi/admin/power-bi-allow-list-urls

 

And then there's this:

  • Gateways enabled for Power BI private endpoints will not work properly with non-Power BI scenarios. A potential workaround is to turn off Private Links, config the gateway, and then reenable the Private Links.

Thanks I guess the below answers it.  They don't in fact work together.  Thanks for pointing that out and sorry I missed it.  But at least it sounds like I can hopefully work around the limitation. 

 

  • Gateways enabled for Power BI private endpoints will not work properly with non-Power BI scenarios. A potential workaround is to turn off Private Links, config the gateway, and then reenable the Private Links.

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.