Dataset operations

 

Updated: June 12, 2017

A Dataset resource path is a collection of Tables owned by a signed in Power BI user. A Table has Rows and Columns that contain data. Using the Power BI Rest API, you can create new datasets and add data to the tables in those datasets. A dashboard that uses those datasets will automatically update when new data is available.

The Power BI REST API has the following Dataset operations:

  • Get Datasets: Returns a JSON list of all Dataset objects that includes a name and id.
  • Create Dataset: Creates a new Dataset object from a JSON schema definition.

Dataset JSON

A Dataset has a collection of Table objects.

Copy 
{  
   "name": "dataset_name",  
   "tables":[  
    …  
    ]  
}

Table JSON

Tables have a name and a collection of Column objects. A Column has a name and dataType.

Copy 
{  
     "name": "table_name",  
     "columns":[  
        {  
           "name": "column_name",  
           "dataType": "data_type"  
        },  
    …  
    ]  
}
Show: