Get Datasets ID by name over Rest API

[Anonymous]

Hi All,

I need to get datasets id by name

In workspace avaialbel a lot of datasets, but I need to find datasets id specificly for one datasets by name.

$uri = https://api.powerbi.com/v1.0/myorg/groups/$groupId/datasets
$datasets = Invoke-RestMethod -Headers $header -Uri $uri -Method "GET"
$datasetsVal = $datasets.value
$datasetsId = $datasetsVal.id

 Above script return all IDs. but I need get ID by name.

Thanks for help 

[Anonymous · Accepted solution]

Hi @Anonymous 

Currently, there is no suitable REST API to retrieve the dataset ID according to the dataset name. You can search all the datasets under this workspace through the workspace ID, then export the results, and then return the dataset ID according to the dataset name.

https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/get-datasets-in-group

If you are not sure of the workspace ID, you can get the dataset information of the entire organization through the following API, and then retrieve the dataset ID through the dataset name.

https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/get-datasets

Best Regard

Community Support Team _ Ailsa Tao

[nitishsh91]

You can try working it out via PowerShell if you want to

https://docs.microsoft.com/en-us/powershell/module/microsoftpowerbimgmt.data/get-powerbidataset?view...

You can also try using this API to find all datasets and look for the one that you want:

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

Get the output from above and then filter out based on name and use that id.