Connector Issues Between Tableau and ADLS2

Question

I am having issues connecting our ADLS2 environment to Tableau.

I am able to connect to ADLS using the ‘ADLS Gen2 > File URL’ connection type but not the ‘ADLS Gen2 > Browse’ connection type.

We have a .parquet file in there that we want to read and that is not one of the file extension options for the File URL connection type. The connection and access seem to be valid since we are able to read files directly from it using the ‘File URL’ connection so we are unsure what is causing the issue.

We receive the error message: "Azure Data Lake Storage Gen2 was unable to process this request. Please report this problem to Tableau." But they haven't been very helpful so far. I was hoping someone else might have run into a similar issue.

Answer 1

"Azure Data Lake Storage Gen2 was unable to process this request. Please report this problem to Tableau."

If the service principal or user doesn’t have permissions to read or perform the operations, you will get the above error. To resolve the error, add storage data reader or storage data owner role to the account as follows:

Step 1: Go to IAM of storage account, click on Add, and select Add role assignment as shown below:

Step 2: Search for the role and select it as shown below:

Step 3: Select the account or user as mentioned below:

After successful role assignment, you will be able to read files or list the files in the container. For more information, you can refer to this.