Azure Synapse Link Dataverse External Table issue

Seishu Morales 21 Reputation points
2022-08-25T19:54:01.957+00:00

Hello I synced Azure Synapse Link to Dataverse in powerapps which creates External Tables/Data Source/ File Format in my Storage Gen 2 account container.

However, I ran into an issue running a simple query with one of the external tables in Synapse Workspace.

-I need help identifying the error below:

"External table 'name of table' is not accessible because content of directory cannot be listed."

The permissions in my storage account are:
-Contributor
-Storage Blob Data Owner
-Storage Blob Table Data Contributor

-I am also a Synapse Administrator.

-Firewalls setting is set to "Enabled from all networks".

-Also have a Serverless SQL pool.

Thank you

Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,337 questions
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,358 questions
0 comments No comments
{count} votes

Accepted answer
  1. BhargavaGunnam-MSFT 25,971 Reputation points Microsoft Employee
    2022-08-26T18:11:09.8+00:00

    Hello anonymous user,

    Welcome to the MS Q&A platform.

    If you are using the Synapse link for Dataverse to read the linked DataVerse tables, you need to use the Azure AD account to access the linked data using the serverless SQL pool. For more information, see Azure Synapse Link for Dataverse with Azure Data Lake.

    If you try to use a SQL login to read an external table that is referencing the DataVerse table, you will get the following error:

    External table 'table_name' is not accessible because content of directory cannot be listed.

    Dataverse external tables always use Azure AD passthrough authentication. You can't configure them to use a shared access signature key or workspace managed identity.

    Please see the below document explaining this error.

    https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/resources-self-help-sql-on-demand?tabs=x80070002#content-of-dataverse-table-cant-be-listed

    ------------------------------

    • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification
    • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators

0 additional answers

Sort by: Most helpful