Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Dataset {dataset_id} is not Push API dataset

Hello,

I'm trying to retrieve records from within a dataset/table and i'm receiving the following response:

 

{
    "error": {
        "code": "ItemNotFound",
        "message": "Dataset {dataset_id} is not Push API dataset."
    }
}

This is the GET url i'm using is:

https://api.powerbi.com/v1.0/myorg/groups/{group_id}/datasets/{dataset_id}/tables

The dataset that i'm looking to connect to is an existing dataset.  What exactly is an "Push API dataset"?  Is this a setting from within the dataset itself? I'm fariely inexperieinced in the Power BI API thus far and am looking for a bit of guidance on this prticular issue.  Any help would be greatly apprecaited. 

Need Help

4 Replies

  • Jayendran's avatar
    Jayendran
    Solution Sage
    6 years ago

    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"
        }
      ]
    }
  ]
}
    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Who the heck creates reports in this way.... what use is this API - the expectation is that it performs the way the OP wants it to. Can someone answer the question properly please?

       

      If this one doesn't list the tables used within a Tabular Model/dataset then which API should be used?

       

      Thanks

    • MichelH's avatar
      MichelH
      New Member
      6 years ago

      So there are now 2 ways to create a dataset.

       

      Is there a way to convert between the two? Or to point an existing report to a API ready dataset ?

       

      Can we still use powerbi desktop, to create/modify the report(s) ?

  • sam1231's avatar
    sam1231
    New Member
    1 year ago
    https://api.powerbi.com/v1.0/myorg/groups/{group_id}/datasets/{dataset_id}/tables

    im also facing that problem , and the user who created the report used powerbi desktop , he cant create it using API , is there any solution ?