Microsoft Azure

Failed to load in Azure Synapse Workspace

After last week’s post about how to configure Azure Synapse Link to export data from Dataverse into SQL Server, today a post about some issues. How do you deal witht he failed to load messages that users might get when accessing the data.

Failed to load

When users try to access the data, they may get the failed to load message. The supporting details of the error may say something like Failed to load one or more resources due to no access, error code 403.

How do we go about troubleshooting this issue?

The error message when clicking on the details will also include that there is something wrong with accessing any of the following:

  • Pipeline
  • Dataset
  • Linked service
  • Trigger
  • Data flow
  • SQL script
  • Spark job definition
  • Credential
  • Synapse KQL scripts
  • Lake databases
  • Apache Spark configuration

As I placed all the objects into a resource group, I checked the resource group permissions to include my user(s) that need to access the data.

I also checked what happened when I just click on ok, on the error message and compared this with when I access the workspace with my admin account. And quite quickly it is clear that I don’t have access to the databases.

So how do we give access to users accounts to the data?

Configure Access Control

First of all go to your Azure Synapse workspace, and then open the Synapse Studio

Then Find the Manage option and select Access Control.

This is where you can add other users and give them the roles that they need. Once you have given them access they can access the data.

Share
Pieter Veenstra

Business Applications and Office Apps & Services Microsoft MVP working as a Microsoft Productivity Principal Consultant at HybrIT Services. You can contact me using contact@veenstra.me.uk.

Recent Posts

Create multi user real time apps in Power Apps

When multiple users edit data and you want your app to show real time data,…

2 weeks ago

Sort by Title in your Highlighted Content web part in SharePoint

Yesterday I was asked about how to sort Documents in the Highlighted Content web part…

2 weeks ago

Copy large files from SharePoint to Azure Blob Storage using Power Automate

When you try to copy large files from SharePoint to Azure Bob Storage with Power…

2 weeks ago

Sort an array by dates in Power Automate

When we use the Sort function to sort arrays in Power Automate, it is soo…

3 weeks ago

New! Format data by examples in Power Automate

This feature "Format data by examples" will kill one of my most popular posts! How…

1 month ago

Named formulas in Power Apps using App.Formulas

Do you use the App onstart to set a lot of variables? And then do…

1 month ago
%%footer%%