Unexpected error in the query 'Transform homedailydata file'. (JSON FORMAT ERROR?)

[Anonymous]

I am trying to get data from Azure Blob Storage. 

This is the error I get:

Unexpected error in the query 'Transform homedailydata file'. Expression.Error: Cannot convert a List type value to the Record type.
Details
    Value=List
    Type=Type

This is the content of the file:

[{"voltage_mv":228382,"current_ma":21,"timestamp":"2019-05-12T10:36:25.861711","energy_wh":115,"power_mw":0},{"voltage_mv":228410,"current_ma":22,"timestamp":"2019-05-12T10:36:30.942967","energy_wh":115,"power_mw":0},{"voltage_mv":228302,"current_ma":22,"timestamp":"2019-05-12T10:36:35.877081","energy_wh":115,"power_mw":0},{"voltage_mv":228331,"current_ma":21,"timestamp":"2019-05-12T10:36:40.957370","energy_wh":115,"power_mw":0},{"voltage_mv":228565,"timestamp":"2019-05-12T10:37:19.149209","current_ma":22,"energy_wh":115,"power_mw":0},{"timestamp": "2019-05-11T23:45:06.875618", "current_ma": 21, "power_mw": 0, "energy_wh": 0, "voltage_mv": 0}]

It is just power consumption values and the timestamp when they were measured (every 5 seconds).

Can anyone offer any help?

[v-juanli-msft]

Hi @Anonymous 

Here is a similar thread you could refer to:

import JSON files from an Azure Blob Storage

If it doesn't help, please share me the code in Advanced editor untill the error shows.

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.