Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.