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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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.