AML Studio - cannot create dataset from datastore file

Hannah Bavcic 1

I am using Jupyter notebooks to work in AML. I was able to upload a file to a datastore (the default workspaceblobstore), but am receiving an error when I try to create a dataset using this file. The relevant code is below:

#This part works

datastore = ws.get_default_datastore()

datastore.upload_files(files = ['data/german_credit_dataset.csv'], overwrite = True, show_progress = True)

# This part doesn't

dataset = Dataset.Tabular.from_delimited_files(path = [(datastore ,'german_credit_dataset.csv')])

I know the file was uploaded correctly as I am able to locate it in the datastore, and manually create a dataset. The error I receive is:

code": "UserError",
"message": "Cannot load any data from the specified path. Make sure the path is accessible and contains data.\nScriptExecutionException was caused by DatastoreResolutionException.\r\n DatastoreResolutionException was caused by UnexpectedException.\r\n
Could it be a permissions issue? I used the json file to connect to my compute instance and it seems to work since I was able to upload the file.

YutongTie-MSFT 51,756 Reputation points

2020-11-13T10:31:41.317+00:00

Hello,

What's the code you are using for JSON? Thanks.

Regards,
Yutong
Hannah Bavcic 1 Reputation point

2020-11-13T11:25:47.537+00:00
Hi,

The JSON is the automatically generated config file, which has this format:

{ "subscription_id": "xxxx", "resource_group": "hannahbav", "workspace_name": "HB_machine_learning" }

Thanks,
Hannah
romungi-MSFT 46,141 Reputation points Microsoft Employee

2020-11-26T16:17:34.877+00:00
@Hannah Bavcic Could you try something like this to retrieve your csv file?

dataset = Dataset.Tabular.from_delimited_files(path = [(datastore, ('data/german_credit_dataset.csv'))])
YutongTie-MSFT 51,756 Reputation points

2020-11-30T10:34:33.023+00:00

Hello,

Could you please check if Rohit's workaround for your problem? Thanks.

Regards,
Yutong

Share via

AML Studio - cannot create dataset from datastore file

Your answer