dataset.to_pandas_dataframe() throws a ScriptExecution.StreamAccess.Authentication error

Antara Das 376 Reputation points
2021-11-29T13:57:04.63+00:00

Azure fails to connect with the Dataset citing 403 inspite of SAS token
This appears when we try to load the data as a pandas dataframe . dataset = Dataset.get_by_name() works

Error message:

{
"error": {
"code": "UserError",
"message": "Execution failed in operation 'to_pandas_dataframe' for Dataset(id='data id', name='dataset name', error_code=ScriptExecution.StreamAccess.Authentication,error_message=ScriptExecutionException was caused by StreamAccessException.\r\n StreamAccessException was caused by AuthenticationException.\r\n Authentication failed for 'AzureBlob GetReference' operation at '[REDACTED]' with '403: AuthenticationFailed'. Please make sure the SAS token or the account key is correct.\r\n Failed due to inner exception of type: StorageException\r\n| session_id=session_id) ErrorCode: ScriptExecution.StreamAccess.Authentication"
}
}

Azure Machine Learning
Azure Machine Learning
An Azure machine learning service for building and deploying models.
2,571 questions
Azure Blob Storage
Azure Blob Storage
An Azure service that stores unstructured data in the cloud as blobs.
2,436 questions
0 comments No comments
{count} vote

Accepted answer
  1. Antara Das 376 Reputation points
    2021-11-30T13:29:23.5+00:00

    The problem was solved by updating the account keys in the workspace.
    az ml workspace sync-keys -w mlw-kundenscore -g rg-datascience

    1 person found this answer helpful.
    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. GiftA-MSFT 11,151 Reputation points
    2021-11-30T01:44:50.843+00:00

    Hi, some suggestions include:


    --- *Kindly Accept Answer if the information helps. Thanks.*

    1 person found this answer helpful.