Cannot connect PlainText (JSON) to dataset on Azure Machine Learning

Question

I uploaded the PlainText file in JSON format to the new Azure Machine Learning Studio (studio.azureml.net), but I cannot connect the PlainText object to any module. I constantly get the error "Unable to connect PlainText to the dataset ...".

The documentation ( here ) says that “Plain text can be read and then broken down into columns using downstream preprocessing modules.”, But I cannot find downstream preprocessing modules.

Answer 1

In fact, Azure ML cannot process JSON data. This will probably be added in a future update, but the easiest way (in my opinion) is to use this data to convert it to CSV format. This can be done quickly with Power Query. Then you load the CSV file into a new dataset.