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.
When publishing PBI Dataset (bim) through XMLA enpoint with table similar to below:
...
{
"name": "Some Table",
"description": "",
"isHidden": true,
"lineageTag": "afa5812e-ff59-4529-ab9a-ff1dfabc36b8",
"columns": {
"name": "Only One Column",
"dataType": "string",
"sourceColumn": "Some Source Column",
"lineageTag": "20c8e1f2-e27b-41ce-84d7-2db9568c8e3b",
"summarizeBy": "none",
"annotations": [
{
"name": "SummarizationSetBy",
"value": "Automatic"
}
]
},
"partitions": [
...
Receive an error: The JSON DDL request failed with the following error: <ccon>Cannot read object collection with item type 'Column' from json object which is not an array of objects. Check path 'model.tables[14].columns'
It asks for columns object to be an array. If you wrap it in [] or add another column to the table all works fine.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @gshapiev
You mean you put the column name in [] , then it works fine , if you don't put it in [] , publish dataset will be an error ?
Best Regards,
Community Support Team _ Ailsa Tao