I have trouble creating a dataset with multiple tables via PowerBI RestAPI call

[Anonymous]

I created a C# app, which can create a dataset I define via json format inside my PowerBI workspace. This works fine, if I create a dataset, which has only one table like the following: 

string datasetJson = "{\"name\":\"TestSeveralTables\",\"defaultMode\":\"Push\",\"tables\": " + 
"[{\"name\":\"ABC1\",\"columns\": [{\"name\":\"abc_abc1\",\"dataType\":\"string\"}, " +
"{\"name\":\"value_abc1\",\"dataType\":\"Int64\"}, " + 
"{\"name\":\"time_abc1\",\"dataType\":\"DateTime\"}]}]}";

However if I want to create a dataset with two or more tables I get a server error 400. My datasetJson string for multiple tables looks as follows: 

string datasetJson = "{\"name\":\"TestSeveralTables\",\"defaultMode\":\"Push\",\"tables\": " + 
              "[{\"name\":\"ABC1\",\"columns\": " + 
"[{\"name\":\"abc_abc1\",\"dataType\":\"string\"}," + 
"{\"name\":\"value_abc1\",\"dataType\":\"Int64\"}, " + 
"{\"name\":\"time_abc1\",\"dataType\":\"DateTime\"}]}]}" + 
"[{\"name\":\"ABC2\",\"columns\": " +
"[{\"name\":\"abc_abc2\",\"dataType\":\"string\"}, " + 
"{\"name\":\"value_abc2\",\"dataType\":\"Int64\"}, " + 
"{\"name\":\"time_abc2\",\"dataType\":\"DateTime\"}]}]}";

What am I doing wrong here? Thanks in advance. Best regards. 

[rivo201 · Accepted solution]

Hi. You need to seperate tables with comma. 

{
"name": "SalesMarketing",
"defaultMode": "Push",
"tables":    [
{
"name": "Table1",
"columns": [
             { "name": "ProductID", "dataType": "Int64" }
           ]
},
{
"name": "Table2",
"columns": [
             { "name": "ProductID", "dataType": "Int64" }
           ]
  }
 ]
}