Cannot find the credential "https/datalake/file.parquet" because it does not exist or you do not have permission

Question

Hello,

I'm using Synapse Serverless Pool and created a view with a query that access a parquet file stored in our data lake.

I'm the owner and I can run the view without issues using the On SQL on demand endpoint.

I would like now to create a user that can access the the SQL Endpoint and access the view?

Create a Sql Login gave reader permission, but maybe this is not enough since it cannot access the Azure Data Lake Storage.

Any idea?

Thanks

Answer 1

The most common reason for this error is the user does not have the Storage Blob Data Contributor on the Storage account. This is required even if you have owner permissions on the account.

Please let me know if this solves the issue or if we need to go through some more troubleshooting.

Answer 2

I have the exact same issue. I have added my MSI to the Storage Blob Data Contributor on the storage account and to the db_datareader role on the SQL endpoint resulting in: ERROR: Cannot find the CREDENTIAL 'msi_cred', because it does not exist or you do not have permission.Msg 15151

If I add the MSI to the db_owner role on the SQL endpoint it works - even if I remove Storage Blob Data Contributor access on the storage account.

Answer 3

I'm having the same issue when i try to connect to a datasource in power bi, "Erro do OLE DB ou do ODBC : [DataSource.Error] Microsoft SQL: Cannot find the CREDENTIAL". Did anyone fix this ?