Forum Discussion
Fabric SQL Analytics Endpoint to Power BI Desktop Security Concerns
- 1 year ago
Hello ERWeiss
Microsoft Fabric’s private endpoints securely route SQL analytics traffic through Azure’s private network backbone, bypassing public internet exposure even with port 1433 blocked.
Private endpoints reroute Fabric SQL analytics traffic through Microsoft’s backbone network (not public internet), while still using TCP 1433.
• Port blocking on public networks won’t affect private-link connections since traffic never leaves Azure’s secure infrastructure.
• Requires enabling Block Public Internet Access in Fabric admin settings to enforce private routing
Enable Block Public Internet Access in Fabric admin settings to enforce private routingValidate DNS resolution to private IPs using `nslookup`.
• Confirm NSGs allow outbound port 1433 within the VNetBy configuring private endpoints and internal NSGs correctly, you can securely use Fabric SQL endpoints while complying with port-blocking policies.
What impacts does this process have on Power BI Functionality? I believe I saw that it prevents subscriptions?
You are correct.
Enabling private endpoints and blocking public internet access in Power BI introduces several limitations Such as
Email subscriptions are not supported
Exporting reports to PDF, PowerPoint, or Excel is not supported
These are few examples