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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Anonymous
Not applicable

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. 

4 REPLIES 4
sam1231
New Member

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 ?

Jayendran
Solution Sage
Solution Sage

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
Not applicable

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

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) ?

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

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