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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

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

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. 

1 ACCEPTED SOLUTION
rivo201
Helper I
Helper I

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" }
           ]
  }
 ]
}

 

 

View solution in original post

1 REPLY 1
rivo201
Helper I
Helper I

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" }
           ]
  }
 ]
}

 

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.