Idea Options
- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
0
Issue. Bug when publishing dataset through XMLA endpoint when table has only one column
Submitted by
gshapiev
on
07-28-2022
02:17 PM
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.
See more ideas labeled with:
Comments
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Latest Comments
-
bematth
on: Copying Table with Filters is Ignoring Filters
- tbuck on: March 2025 Update - Error fetching data for this v...
- glendrewsATL on: Snowflake connector isn't showing views after Marc...
- Tomasz_Skoczyla on: March 2025 update - Style preset error
- TwanVerdonschot on: Conditional Formatting - Field Value not working a...
- OFBReporting on: Stretched App's Logo in Home Page "Recommended"
- pedrodr99 on: Button Slicer - Label - Color change not working
-
v-xiaoyan-msft on: Default Chart - Shape Map Is Not Working As Expect...
-
v-xiaoyan-msft on: Error (Exception from HRESULT: 0x80070002)
-
v-xiaoyan-msft on: Card (new) - SVG images dont render correctly
Idea Statuses
- New 7,872
- Needs Info 3,502
- Investigating 3,602
- Accepted 2,084
- Declined 38
- Delivered 3,964
-
Reports
10,149 -
Data Modeling
4,093 -
Dashboards
4,082 -
Gateways
2,103 -
Report Server
2,099 -
APIS and Embedding
1,951 -
Custom Visuals
1,770 -
Content Packs
521 -
Mobile
353 -
Need Help
11 -
Show and Tell
3 -
General Comment
2 -
Power BI Desktop
1 -
Tips and Tricks
1