Forum Discussion
Array datatype in post dataset power bi rest api
{
"name": "SalesMarketing",
"defaultMode": "Push",
"tables": [
{
"name": "Product",
"columns": [
{
"name": "reportRefreshDate",
"dataType": "DateTime"
},
{
"name": "userPrincipalName",
"dataType": "string"
},
{
"name": "displayName",
"dataType": "string"
},
{
"name": "isDeleted",
"dataType": "bool"
},
{
"name": "deletedDate",
"dataType": "DateTime"
},
{
"name": "lastActivityDate",
"dataType": "DateTime"
},
{
"name": "sendCount",
"dataType": "Int64"
},
{
"name":"receiveCount",
"dataType": "Int64"
},
{
"name":"readCount",
"dataType": "Int64"
},
{
"name":"meetingCreatedCount",
"dataType": "Int64"
},
{
"name":"meetingInteractedCount",
"dataType": "Int64"
},
{
"name":"assignedProducts",
"dataType": "array"
},
{
"name": "reportPeriod",
"dataType": "string"
}
]
}
]
}
Is it possible to hazve array datatype in dataset table schema
1 Reply
The equivalent to an array would be a table. However a dataset data source needs to be in tabular form, with atomic rows and columns, to be consumable by Power BI. AFAIK you cannot access table, list, record etc data types from Power BI (even though Power Query does allow you to keep them as query results)
