早上好,
目标:我正在尝试为SSAS Tabular模型表添加新列。 长期目标是在需要时通过编程方式进行大批量更改。
这个网站提供了我一直在遵循的模板,但似乎不起作用。
我已经尝试过的方法:
{
"create": {
"parentObject": {
"database": "TabularModel_1_dev"
, "table": "TableABC"
},
"columns": [
{
"name": "New Column"
, "dataType": "string"
, "sourceColumn": "Column from SQL Source"
}
]
}
}
第一个示例最符合要求,但是会返回以下错误:
"The JSON DDL request failed with the following error: Unrecognized JSON property: columns. Check path 'create.columns', line 7, position 15.."
尝试二:
{
"create": {
"parentObject": {
"database": "TabularModel_1_dev"
, "table": "TableABC"
},
"table": {
"name": "Item Details by Branch",
"columns": [
{
"name": "New Column"
, "dataType": "string"
, "sourceColumn": "New Column"
}
]
}
}
}
在子列表中添加表格也会返回错误;
"...Cannot execute the Create command: the specified parent object cannot have a child object of type Table.."
在parentObject中省略表格也是不成功的。