Skip to main content

Notifications

Power Automate - Using Connectors
Unanswered

Parse an array from a JSON to Power BI

(0) ShareShare
ReportReport
Posted on by 2

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:

 

William_Lima_0-1593030485320.png

             William_Lima_1-1593030540349.png

 

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.
 
 

 

 

 

 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,508

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,839

Leaderboard

Featured topics