topic Re: Error While Connecting to Azure Storage Connector in Integration, Extension & APIs

Error While Connecting to Azure Storage Connector

Kartik2 — Wed, 06 Mar 2024 06:59:50 GMT

I want to connect to azure blob storage ,after the getting the authentication key from azure ,also getting our account info as well,when i clicked on "Test Conection" ,I got the below error.
Note:- The account in which I was configuring the connection in qlik is different from the azure account from which I want the data from.

The azure account holder has all the necessary permissions for that storage container.

Re: Error While Connecting to Azure Storage Connector

Rohit-Prakash — Wed, 06 Mar 2024 08:53:18 GMT

@Kartik2 You must set an encryption key if you're using a connector with Qlik Sense Desktop or Qlik Sense Enterprise on Windows.: https://help.qlik.com/en-US/connectors/Content/Connectors_Home/Setting-encryption-key.htm

Azure Storage: https://help.qlik.com/en-US/connectors/Subsystems/Web_Storage_Provider_Connectors_help/Content/Connectors_StorageProvider/Storage%20provider%20connectors/Azure-Storage-storage-provider-connector.htm

Re: Error While Connecting to Azure Storage Connector

Kartik2 — Wed, 06 Mar 2024 08:55:48 GMT

Yes @Rohit-Prakash ,Done that!

Re: Error While Connecting to Azure Storage Connector

Rohit-Prakash — Wed, 06 Mar 2024 09:05:13 GMT

@Kartik2 Can you please confirm which version you are using currently?
Ensure that the credentials you are using to connect from Qlik to Azure are correct. This includes any usernames, passwords, or authentication tokens required for the connection.

Re: Error While Connecting to Azure Storage Connector

Kartik2 — Wed, 06 Mar 2024 09:06:55 GMT

Does the user using Qlik sense and the user of azure account has to be the same?

Re: Error While Connecting to Azure Storage Connector

Rohit-Prakash — Wed, 06 Mar 2024 09:18:26 GMT

@Kartik2 No, the user using Qlik Sense and the user of the Azure account do not necessarily have to be the same person. In many cases, different individuals or teams may be responsible for managing and using Qlik Sense for data analysis and accessing Azure services for data storage, processing, or other purposes.

However, it's essential to ensure that the user account being used in Qlik Sense has the appropriate permissions and access rights configured within Azure to interact with the required Azure resources.
You test the connection with the same user.

Azure Storage supports the below versions.

Qlik Sense Business
Qlik Sense Enterprise SaaS (as of v0.69)
Qlik Sense Enterprise on Windows (as of v4.18.0 / May 2022)
Qlik Sense Desktop (as of v4.18.0 / May 2022)

Re: Error While Connecting to Azure Storage Connector

Kartik2 — Wed, 06 Mar 2024 10:42:28 GMT

Thanks @Rohit-Prakash we'll do the needful

Re: Error While Connecting to Azure Storage Connector

Kartik2 — Thu, 07 Mar 2024 06:46:10 GMT

@Rohit-Prakash Which means the user who is configuring the connection in qlik ,should have a azure account as well, and that azure account should have necessary access roles/permissions?

Re: Error While Connecting to Azure Storage Connector

Rohit-Prakash — Thu, 07 Mar 2024 08:30:57 GMT

@Kartik2 When you authenticate the Azure Storage Web Storage Provider Connector, access to content is granted based on the Identity and Access Management (IAM) configuration on Microsoft Azure. For guidance on determining an appropriate policy, including the ability to scope to specific files/permissions such as control over read/write see Assign an Azure role for access to blob data. Any user granted Can edit/Can edit data in apps/Can consume data (Shared spaces) or Can consume data/Can manage (Managed spaces) roles to the Azure Storage data connection's space can view files in the configured Azure container as defined by the IAM user's policy.

Re: Error While Connecting to Azure Storage Connector

Kartik2 — Thu, 07 Mar 2024 09:17:16 GMT

@Rohit-Prakash I'm using suppose 'X' account to authenticate into the azure portal ,then when i paste the verifying code and test the connection, I get an error that "This request is not authorized to perform this operation using this permission" ,even though 'X' has been assigned 'Storage Blob Contributor' role for that storage account.
Are any other roles also required to be assigned?

Re: Error While Connecting to Azure Storage Connector

Rohit-Prakash — Thu, 07 Mar 2024 09:35:09 GMT

@Kartik2 When authoring load/store scripts for use with the Azure Storage Web Storage Provider Connector, there are specific limitations to be aware of, due to the internal file structure of Azure Storage blobs.

In your Microsoft Azure portal, you must enable the following user permissions to access the blob container: Storage Blob Data Contributor, and Storage Blob Data Reader.
Accessing folders within the top level blob container are not supported, for load or store syntax.
Using the filesize/filetime commands on the 'root' blob container itself is not supported.
Wildcard/masking syntax is not supported. You may only load specified individual files, or all files in a specified folder.
When using Qlik Sense Enterprise on Windows, the Include command is not supported.

You can refer to the Microsoft Azure Blob service REST API documentation to learn more about the requirements and restrictions imposed by the API.

Microsoft Azure Blob service REST API