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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
to_be_calm
Helper I
Helper I

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors