Need to get the particular datasetid and report id using rest api filter calls.

[maruboyinarao]

In my work space i need to get the particular datasetid and report id using rest api filter calls.

In below ADO[Dev] is my workspace, in that i have two datasets will be there. i need to get the "Embedded_**-DemoIV" datasetid reportid using rest API.

using the "GET https://api.powerbi.com/v1.0/myorg/groups/{groupId}/datasets" api calls i am getting both datasets  information , help me on this to get the right datasetid and report id  information based on the filter.

[V-pazhen-msft]

@maruboyinarao 

https://api.powerbi.com/v1.0/myorg/admin/reports?$filter={$filter}&$top={$top}&$skip={$skip}

Try the get datasetasadmin, follow the code with parameters. 

Admin - Datasets GetDatasetsAsAdmin - REST API (Power BI Power BI REST APIs) | Microsoft Docs

Admin - Reports GetReportsAsAdmin - REST API (Power BI Power BI REST APIs) | Microsoft Docs

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[maruboyinarao]

How can we use filter, any suggentions on that? i tried with below api calls but those are not working.

#Get Workspace Information
$uri = "https://api.powerbi.com/v1.0/myorg/groups?$filter=(name eq '$WorkspaceName')"

#Get Report

$uri = "https://api.powerbi.com/v1.0/myorg/groups/$workspaceID/reports?$filter=(name eq '$reportName')"

[ponnusamy]

@maruboyinarao : You need to pass GUID not the description.

If this post helps, then please consider Accepting it as the solution, Give Kudos to motivate the contributors.

[ponnusamy]

@maruboyinarao : I don't think the current APIs support filter by 'name' of dataset. I would suggest you to pull the details using the API 

https://api.powerbi.com/v1.0/myorg/groups/{Your Group}/datasets

And filter out the dataset based on the name

  "value": [
    {
      "id": "0c686fd",
      "name": "YOUR DATA SET NAME",
      "addRowsAPIEnabled": false,
      "configuredBy": "",
      "isRefreshable": true,
      "isEffectiveIdentityRequired": false,
      "isEffectiveIdentityRolesRequired": false,
      "isOnPremGatewayRequired": true,
      "targetStorageMode": "Abf",
      "createReportEmbedURL": "",
      "qnaEmbedURL": "2",
      "upstreamDatasets": [],
      "schemaMayNotBeUpToDate": false,
      "users": []
    },

If this post helps, then please consider Accepting it as the solution, Give Kudos to motivate the contributors.