Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Get the dataset ID and add it to a POWER BI REST API command

I would like to retrieve the id of a dataset via this command :

 

Get-PowerBIDataset -Scope Organization -Name "REPORT FINANCE DEV"

 

Then, I would like to integrate it in this command instead of the hard number sequence.

 

$body ='{
"updateDetails": [
{
"name": "WKS_NAME_PARAM",
"newValue": "WKS"
}
]
}'
Invoke-PowerBIRestMethod -Url "https://api.powerbi.com/v1.0/myorg/datasets/ 1cd873be-50b9-4b71-a35f-a58b7dd9f6c2/Default.UpdateParameters" -Method Post -Body $body

 

Can anyone help me ?

 
Thanks in Advance, 
 
Charline
General Comment
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

2 Replies

  • Hariharan_R's avatar
    Hariharan_R
    Solution Sage
    4 years ago

    Hi Anonymous 

    Use the below script.

     

    $dataset = Get-PowerBIDataset -Scope Organization -Name "SharePoint_Web"
$dataset_id=$dataset.id


$body ='{
"updateDetails": [
{
"name": "WKS_NAME_PARAM",
"newValue": "WKS"
}
]
}'

$url = "https://api.powerbi.com/v1.0/myorg/datasets/ $dataset_id/Default.UpdateParameters"

Invoke-PowerBIRestMethod -Url $url -Method Post -Body $body

     

    Thanks

    Hari

    Did I answer your question? Then please mark my post as the solution.
    If I helped you, click on the Thumbs Up to give Kudos.

    My Blog :: YouTube Channel :: My Linkedin


    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi Hariharan_R, 

       

      I tried your code but I got this error.