Excel Power Query-是否可以通过SAS身份验证或Azure AD帐户连接到Azure Blob存储 [英] Excel Power Query - Is it possible to connect to Azure Blob Storage with SAS authentication or Azure AD account

问题描述

我正在使用Excel从Azure Blob存储中访问容器，我们通过新建查询"进行连接，但仅提供使用帐户密钥进行访问的选项.

记录权限后，使用帐户密钥将权限保存在数据源"设置中.

使用Power Query AzureStorage.Blobs(

如果使用Power Query，请选择新建源"->其他源"->"Web"，然后与excel获取数据相同.

I am accessing a container from a Azure Blob Storage with Excel, we connect through "New Query" but only gives the option to access with the Account Key.

After logging the permissions are saved in Data source setting with the Account Key.

To access that Azure Blob Storage from VBA is enough with the function from Power Query AzureStorage.Blobs (https://docs.microsoft.com/en-us/powerquery-m/azurestorage-blobs).

¿Is It possible to do the same with SAS (Shared Access Signature) Token or Azure AD account instead of using the Account Key? I've looking and found nothing at the moment

解决方案

Yes, you could connect with sas, however it's not data from azure, in my test it could work with from web.

I generate the sas url with read,write permissions and use HTTP protocol, then in the excel paste the url and replace https to http. Then you will be able to get the data.

If use Power Query, choose New Source-> Other Sources-> Web then it's same with excel get data.

这篇关于Excel Power Query-是否可以通过SAS身份验证或Azure AD帐户连接到Azure Blob存储的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！