Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet 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
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()
Solved! Go to 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.
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).
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.
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.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
39 | |
27 | |
21 | |
21 | |
10 |
User | Count |
---|---|
44 | |
36 | |
35 | |
20 | |
14 |