Content of directory on path 'https://datalakecohswtr.dfs.core.windows.net/files/sales/csv/**' cannot be listed.

Question

Content of directory on path 'https://datalakecohswtr.dfs.core.windows.net/files/sales/csv/**' cannot be listed.

Adeymola 0

I am trying to View Top 100 row of my file but it keeps bringing up error

Syed Aaqid Ali 580 Reputation points Microsoft External Staff Volunteer Moderator

2025-05-20T22:53:53.06+00:00
Hello Adeymola,

As you are trying to View Top 100 row of files but it keeps bringing up error, could you please confirm what tool are you using to access the data?

Can you list files from other folders in the same storage container?

Can someone else with similar access list the contents?

Have you tried it from a different network?

Do you see any specific error messages or error codes in the response?
Syed Aaqid Ali 580 Reputation points Microsoft External Staff Volunteer Moderator

2025-05-21T16:42:49.54+00:00

Hello Adeymola,

Could you please confirm if you’ve had a chance to review the above comment, so we can proceed with investigating the issue?

Additionally, I've initiated a private message to gather additional information for a closer investigation.

1 answer

Your answer

Syed Aaqid Ali 580 Reputation points Microsoft External Staff Volunteer Moderator

2025-05-20T22:53:53.06+00:00

Hello Adeymola,

As you are trying to View Top 100 row of files but it keeps bringing up error, could you please confirm what tool are you using to access the data?

Can you list files from other folders in the same storage container?

Can someone else with similar access list the contents?

Have you tried it from a different network?

Do you see any specific error messages or error codes in the response?
Syed Aaqid Ali 580 Reputation points Microsoft External Staff Volunteer Moderator

2025-05-21T16:42:49.54+00:00

Hello Adeymola,

Could you please confirm if you’ve had a chance to review the above comment, so we can proceed with investigating the issue?

Additionally, I've initiated a private message to gather additional information for a closer investigation.

Answer 1

Hello Adeymola,

As part of investigation unfortunately we lack in enquiring few details from your end however based on the error message "Content of directory on path cannot be listed" typically indicates that the user querying Azure Data Lake does not have the necessary permissions to list the files in the specified directory. This can occur for several reasons:

The Microsoft Entra user does not have permission to list the files in Data Lake Storage.
The Microsoft Entra ID or SQL user accessing the data does not have the required permissions.
The user may not have the necessary permissions to read the Delta Lake Storage.

To resolve this issue, you can grant user the Storage Blob Data Contributor and Reader role in the storage account you are trying to query. This role will provide the necessary permissions to list and access the files.

I would also recommend checking Can't read, list, or access files in Azure Data Lake Storage

Please do not forget to "Accept the answer” and “up-vote” wherever the information provided helps you, this can be beneficial to other community members. User's image

If you have any other questions or this answer is not helpful, let me know in the "comments" and help me with the questions asked above so that I can proceed with investigating this issue?

Syed Aaqid Ali 580 Reputation points Microsoft External Staff Volunteer Moderator

2025-05-23T21:07:06.0833333+00:00

Hi Adeymola,

I wanted to follow up and see if the solution proposed helped (pointed you in the right direction) > please do not forget to “up-vote”. which might be beneficial to other community members reading this thread. And, if you have any further queries do let us know.

Share via

Content of directory on path 'https://datalakecohswtr.dfs.core.windows.net/files/sales/csv/**' cannot be listed.

1 answer

Your answer