We have a dataset stored as an .xlsx blob in Azure storage blob container. We do not allow anonymous access to storage accounts.
When I try to add data set in Power BI Desktop, I get "Public access is not permitted on this storage account".
Needless to say but we cannot allow anonymous access. We do have public access enabled at the network level:
I have also tried to use Web data set and using SAS key but run into similar issue. Do I really need to enable "anonymous" access in order to access .xlsx stored in a blob storage in Azure? Is there a secured way to access .xlsx storage in a blob storage in Azure?
Hi @anaib ,
1. When Blob Storage receives an anonymous request, the request will succeed if all of the following conditions are met:
1) Allow anonymous public access to storage accounts.
2) The container is configured to allow anonymous public access.
3) This request is for read access.
If an anonymous request is made using a version of the service that does not support bearer challenges and the storage account is not allowed anonymous public access, the service returns error code 409 (Conflict). For more details, please refer to the link: Public access is not permitted on this storage account - Microsoft Community Hub.
2. Secure connection to Azure Blob Storage can be done using Shared Access Signature (SAS). For more details, please refer to the link: Azure Blob Storage - Power Query | Microsoft Learn.
If your Current Period does not refer to this, please clarify in a follow-up reply.
Best Regards,
Clara Gong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
