Error: Cannot find the CREDENTIAL for Synapse Link Storage – Power BI/SQL Access Issue

Question

Hello Community,

I’m encountering the following error while trying to access a Synapse Serverless SQL pool in Power BI or directly via SQL:

Error Message:
DataSource.Error: Microsoft SQL: Cannot find the CREDENTIAL 'https://synapselinkprd.dfs.core.windows.net/dataverse-customer-orgea8db7e8/appointment/*.csv', because it does not exist or you do not have permission.

Details:

DataSourceKind=SQL

DataSourcePath=customer-synapse-workspace-ondemand.sql.azuresynapse.net;dataverse_customer_orgea8db7e8

Message=Cannot find the CREDENTIAL 'https://synapselinkprd.dfs.core.windows.net/dataverse-customer-orgea8db7e8/appointment/*.csv', because it does not exist or you do not have permission.

ErrorCode=-2146232060

Number=15151

Class=16

State=1

ConnectionId=5d9e0059-1875-42ca-b009-b554e7d47bb1

Answer 1

Hi Abhishek Kathapurkar AITS The error message indicates that the SQL Serverless pool in Synapse is trying to access a credential associated with the storage URL, but it cannot find it or you lack permissions.

Here are some steps to help resolve this:

Check if the credential exists:

SELECT * FROM sys.database_credentials;

If it’s missing, create it (replace <SAS_token> with your actual SAS token):

CREATE DATABASE SCOPED CREDENTIAL [https://synapselinkprd.dfs.core.windows.net/dataverse-customer-orgea8db7e8/appointment/*.csv]  
WITH IDENTITY = 'SHARED ACCESS SIGNATURE',  
SECRET = '<SAS_token>';

Make sure the credential has proper permissions on your storage account (read access at minimum).

Verify Power BI has permission to access Synapse and storage.

If the credential exists but the error persists, try dropping and recreating it.

---

Hope this helps. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.