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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Kudoed Authors