Synapse Link Stuck at Fetching App

In this blog post, we will address a common issue with Synapse Link, where it gets stuck at “Fetching App.” We will provide a step-by-step guide on how to troubleshoot and resolve this problem.

Issue:

Synapse Link Stuck at Fetching App

Troubleshoot

If you encounter the issue of Synapse Link being stuck at “Fetching App,” follow these troubleshooting steps:

1. Set Up a New Link from make.powerapps.com:
   • Head to make.powerapps.com.
   • Create new synapse link
   • Select your Synapse workspace and storage
2. Select Required Tables for Syncing:
   • Choose the tables that you want to sync.
3. Enable Developer Tools in Your Browser:
   • Press F12 to open the developer tools.
   • Navigate to the “Network” tab.
4. Look for a 404 Error:
   • Select create synapse link after selecting tables
   • While in the network tab, look for a 404 error that matches the following description or states “app not found.” This error indicates that Synapse Link is unable to set up a Service Principal in Azure.

404 error when trying a GET request https://graph.windows.net/myorganization/servicePrincipalsByAppId/12345678-77a4-5874-2365-12345678c89b/objectId?api-version=1.6

Resolution

To resolve this issue, follow these steps

1. Launch PowerShell as Administrator with Azure Installed:
   • If you don’t have Azure PowerShell installed, you can follow the installation steps here.
2. Connect to the Tenant:
   • Run the following command: Connect-AzAccount.
   • Ensure you log in with a user who has privileges to create a Service Principal in the tenant, such as a tenant admin or global administrator.
3. Add the Principal:
   • Run this command: New-AzADServicePrincipal -ApplicationId ‘12345678-77a4-5874-2365-12345678c89b’.
4. Try Setting up Synapse Link Again:
   • You should now attempt to set up Synapse Link again. Ideally, this should work without any issues.

By following these steps, you should be able to resolve the “Synapse Link Stuck at Fetching App” issue. If you encounter any further issues, don’t hesitate to seek additional support from your Azure administrators or support team.

Reference: Synapse Link Delta Lake Configuration

Related Article:

Synapse Invalid Object Name