Dataset {dataset_id} is not Push API dataset

Hi Anonymous ,

The problem is you are trying to retrieve the table on the exisiting dataset, which is created from PowerBI Desktop/PowerBI Service. In such case you couldn't able to use this API.

This API is supports only Push DataSet

So what is Push DataSet ? 

Instead of creating the dataset from PowerBI Desktop/Service,you need to create it using API (Push Datasets - Datasets PostDatasetInGroup)

POST https://api.powerbi.com/v1.0/myorg/groups/f089354e-8366-4e18-aea3-4cb4a3a50b48/datasets?defaultRetentionPolicy=basicFIFO

Body:
{
  "name": "SalesMarketing",
  "defaultMode": "Push",
  "tables": [
    {
      "name": "Product",
      "columns": [
        {
          "name": "ProductID",
          "dataType": "Int64"
        },
        {
          "name": "Name",
          "dataType": "string"
        },
        {
          "name": "Category",
          "dataType": "string"
        },
        {
          "name": "IsCompete",
          "dataType": "bool"
        },
        {
          "name": "ManufacturedOn",
          "dataType": "DateTime"
        }
      ]
    }
  ]
}