Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Issue. Bug when publishing dataset through XMLA endpoint when table has only one column

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.

Status: Investigating

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

Comments
v-yetao1-msft
Community Support
Status changed to: Investigating

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

gshapiev
Frequent Visitor

"columns":[{...}] - works. Without [] - you get the above error.