Forum Discussion
Connector Creation not working for Azure Storage Table
Hi KevinDavison
The issue occurs because Power BI Desktop can connect to your Azure Storage Account (since it runs locally with VPN access), but Power BI Service cannot due to network restrictions. When publishing the report, Power BI Service operates from Microsoft’s cloud, which lacks direct access to your storage account behind a VPN. Even after whitelisting Power BI IPs, the service may still be unable to reach the data source. To resolve this, you can set up an On-Premises Data Gateway, which acts as a bridge between Power BI Service and your VPN-protected storage. Alternatively, you can configure Azure Private Endpoints to allow Power BI Service to securely connect without needing a public IP. Another option is using Azure Active Directory (AAD) authentication instead of an account key for a more secure and reliable connection. Lastly, ensure that data source credentials in Power BI Service are correctly set up with OAuth2 or the appropriate authentication method. Since Microsoft confirmed no errors on the storage account side, the issue is likely due to Power BI Service being unable to establish a direct connection.
Hi GilbertQ!
Major apologies, the storage account is on a VNET Gateway, and the IP is whitelisted. My only options for connection seems to be the Access Key only. Anything else I can try?
v-sgandrathiCommunity Support
Hello KevinDavison,
Thankypu for reachingout to Microsoft Fabric Community Forum.
Use Private Endpoint or Service Endpoints:
- Even with VNet Gateway and IP whitelisting, Power BI may need Private Endpoint or Service Endpoints to access the storage account.
- Private Endpoint secures access via the VNet, avoiding public IPs.
- If Private Endpoint is too complex, Service Endpoints can simplify routing Power BI traffic to your VNet.
Ensure Power BI can access the Storage Account:
- Double-check that Power BI has access through the VNet Gateway. Even with IP whitelisting, Power BI may not route properly if the VNet Gateway is not set up correctly to handle external requests to your storage account.
Check Firewall and NSG Settings:
- Since you’re behind a VNet Gateway, make sure there are no Network Security Group (NSG) rules blocking traffic to your Azure Storage account.
Update Access Key:
- Regenerate the Access Key to ensure that it is the correct key and hasn't expired or been rotated.
Here is the microsoft Link on private endpoints for your reference:
Private endpoints for secure access to Power BI for on-premises clients - Power BI | Microsoft LearnPlease Accept as solution if this meets your needs and a Kudos would be appreciated.
- v-sgandrathi
Hi KevinDavison,
As we have not received a response from you yet, I would like to confirm whether you have successfully resolved the issue or if you require further assistance.
If the issue has been resolved, please mark the helpful reply as a "solution" to indicate that the question has been answered and to assist others in the community.
Thank you for your cooperation. Have a great day.- v-sgandrathi
Hi KevinDavison,
As we did not get a response, may I know if the above reply could clarify your issue, or could you please help confirm if we may help you with anything else?
And if the provided information meets your requirements, you can also vote on that. It helps other users who are searching for this same information and find the information.
Your understanding and patience will be appreciated.
- Even with VNet Gateway and IP whitelisting, Power BI may need Private Endpoint or Service Endpoints to access the storage account.