topic Re: Dataset {dataset_id} is not Push API dataset in Developer

Dataset {dataset_id} is not Push API dataset

Anonymous — Fri, 29 Nov 2019 05:24:53 GMT

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.

Re: Dataset {dataset_id} is not Push API dataset

Jayendran — Fri, 29 Nov 2019 06:34:05 GMT

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" } ] } ] }

Re: Dataset {dataset_id} is not Push API dataset

MichelH — Fri, 10 Apr 2020 10:51:20 GMT

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

Re: Dataset {dataset_id} is not Push API dataset

Anonymous — Wed, 01 Sep 2021 18:32:11 GMT

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

Re: Dataset {dataset_id} is not Push API dataset

sam1231 — Mon, 10 Mar 2025 10:19:54 GMT

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 ?