Unable to see the spark pool I have created while configuring the synapse link for dataverse

Athira Reghuraman 95 Reputation points
2024-11-05T11:42:43.1533333+00:00

I have created a spark pool in my synapse workspace to use it for the delta conversion during configuring the synapse link for dataverse for the D365FO data , unfortunately once I choose the synapse workspace and enabled "Use spark pool for delta lake conversion" , it is not showing the spark pool I have created in the dropdown . I have created the spark pool based on the document provided by microsoft and I have owner and synapse admin access

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.
{count} votes

1 answer

Sort by: Most helpful
  1. Vinodh247 39,201 Reputation points MVP Volunteer Moderator
    2024-11-05T16:27:49.6433333+00:00

    Hi Athira Reghuraman,

    Thanks for reaching out to Microsoft Q&A.

    This issue could occur due to several reasons sometimes commonly related to permissions, Spark pool settings or synapse Link configuration nuances.

    1. Ensure that the Spark pool was created with the correct region and settings compatible with Synapse Link requirements for Dataverse. Occasionally, region mismatches or unsupported configurations can cause issues.
    2. Confirm that the Synapse Link and the Synapse workspace are correctly set up, including any specific settings for compatibility with Dataverse and Delta Lake.
    3. Changes in Azure resources aren't immediately reflected. Try refreshing the Synapse Link configuration page, or even re-establishing the connection to your Synapse workspace.
    4. Although you have owner and Synapse admin roles, make sure you have the necessary permissions specifically for Synapse Link with Dataverse, as certain linked access requirements might not be covered by general roles.
    5. Clear cache or try a different browser: Occasionally, cached settings or browser compatibility issues can interfere with resource display in Azure portal dropdowns.

    If there is still issue, consider re deploying the spark pool or checking azure service health to ensure there are no regional disruptions impacting resource visibility.

    Please feel free to click the 'Upvote' (Thumbs-up) button and 'Accept as Answer'. This helps the community by allowing others with similar queries to easily find the solution.


Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.