Hey Guys,
Im in a bit of a situation here, im trying to parse a JSON and create a stream dataset on Power BI. My problem is that I can't get to parse array from the JSON in to the Power Bi Conector, as of now my flow looks like this:


The problem is i can't separate the objects from the array to load on power BI as i get the error below:
[
{
"message": "Invalid type. Expected Array but got Object.",
"lineNumber": 0,
"linePosition": 0,
"path": "",
"schemaId": "#",
"errorType": "type",
"childErrors": []
},
{
"message": "Required properties are missing from object: Prefixo, DataHora, GPS_Latitude, GPS_Longitude, GPS_Direcao, Linha, GTFS_Sentido, Velocidade, IMEI.",
"lineNumber": 0,
"linePosition": 0,
"path": "",
"value": [
"Prefixo",
"DataHora",
"GPS_Latitude",
"GPS_Longitude",
"GPS_Direcao",
"Linha",
"GTFS_Sentido",
"Velocidade",
"IMEI"
],
"schemaId": "#",
"errorType": "required",
"childErrors": []
}
]
This is the schem i'm using:
{
"type": "array",
"required": [
"Prefixo",
"DataHora",
"GPS_Latitude",
"GPS_Longitude",
"GPS_Direcao",
"Linha",
"GTFS_Sentido",
"Velocidade",
"IMEI"
],
"items": {
"type": "array",
"properties": {
"Prefixo": {
"type": "string"
},
"DataHora": {
"type": "string"
},
"GPS_Latitude": {
"type": "string"
},
"GPS_Longitude": {
"type": "string"
},
"GPS_Direcao": {
"type": "string"
},
"Linha": {
"type": "string"
},
"GTFS_Sentido": {
"type": "string"
},
"Velocidade": {
"type": "string"
},
"IMEI": {
"type": "string"
}
}
}
}
Could someone help me ?
Thanks.