Push Dataset create table API

Question

Hello,&nbsp;I've created a push dataset with two tables via API as documented here:&nbsp;Push Datasets - Datasets PostDataset - REST API (Power BI Power BI REST APIs) | Microsoft Learn&nbsp;Now I'd like to add another table to the existing dataset, but couldn't find an API to do this. Can anyone give me a hint how to do this?&nbsp;The PutTable API (Push Datasets - Datasets PutTable - REST API (Power BI Power BI REST APIs) | Microsoft Learn) only allows to change an existing table, but not creating one.&nbsp;BR Stefan

lbendlin · Answer

My experience is that it is faster to start over. Prepare the meta data for both tables, and then (re)fill them. You can use SSMS if that's more convenient for you.

stefankainz · Answer

What do you mean by starting over again? When the push dataset already exists, how can we start over without losing any settings/permissions we have already done?

The scenario is like we have two production machines that collect data in different intervalls, lets say every 10 seconds for machine1 and every 20 seconds for machine2. That are the two tables that already exists. We push data to these two tables via API over the day and delete the data once every night and refill them with the last 4 hours of data.

How to add another table for one more machine (machine3) that collects data every 30 seconds?

lbendlin · Answer

delete all tables and then submit a single combined request to create the new table structures.&nbsp; Then fill these new tables.
&nbsp;
You may be trying to use push datasets in a way that they were not designed for. You may want to look at alternatives like streaming datasets.

stefankainz · Answer

... submit a single combined request to create the new table structuresThat is exactly my trouble. The question is: HOW to create the new table structures?

lbendlin · Answer

Like this
https://learn.microsoft.com/en-us/rest/api/power-bi/push-datasets/datasets-post-dataset-in-group
&nbsp;
&nbsp;
{
  "name": "Demo Export",
  "defaultMode": "Push",
  "tables": [
    { "name": "table1",
      "columns": [
        {
          "name": "Result",
          "dataType": "Int64"
        }
      ]
    },{ "name": "table2",
      "columns": [
        {
          "name": "fieldName",
          "dataType": "string"
        }
      ]
    },{ "name": "table3",
	  "columns": [
		{
		  "name": "ROWID",
		  "dataType": "string"
		}
	  ]
	}
  ]
}
&nbsp;
Looking at my notes it actually seems to be possible to add a table.
https://learn.microsoft.com/en-us/rest/api/power-bi/push-datasets/datasets-put-table-in-group
&nbsp;
{
"name": "table3",
"columns": [
{
"name": "ROWID",
"dataType": "string"
}
]
}
&nbsp;
&nbsp;

Forum Discussion

Push Dataset create table API

9 Replies

Related content

Create new table

Lakehouse Table Generate Create Table

Create rows from 2 tables

Creating tables from a dataset

Creating Date Tables