topic Re: Invoke-PowerBIRestMethod: $top parameter doesn't work when on Refresh history (GET /refreshes) in Developer

Invoke-PowerBIRestMethod: $top parameter doesn't work when on Refresh history (GET /refreshes)

charlieswing — Fri, 10 Jun 2022 16:54:40 GMT

I am trying to use the following GET refreshes method (using Invoke-PowerBIRestMethod Powershell cmdlet) to retrieve refresh history on a particular dataset. I'm wanting to use the {$top} parameter (as mentioned in this PBI documentation) to return the top 1 refresh history however when I run this I get 40+ refresh instances.

I am using this URL:
GET https://api.powerbi.com/v1.0/myorg/datasets/{datasetId}/refreshes?$top=1

I'm thinking this is a bug unless I'm just missing something. Anyone else experiencing this? Again - the api returns refresh history but it does not limit the responses like its supposed to.

Re: Invoke-PowerBIRestMethod: $top parameter doesn't work when on Refresh history (GET /refreshes)

Anonymous — Sat, 11 Jun 2022 14:42:21 GMT

Invoke-PowerBIRestMethod -Url 'https://api.powerbi.com/v1.0/myorg/datasets/{datasetId}/refreshes?$top=1' -Method Get

Re: Invoke-PowerBIRestMethod: $top parameter doesn't work when on Refresh history (GET /refreshes)

charlieswing — Mon, 13 Jun 2022 14:08:22 GMT

@Anonymous Is this an answer? You only posted a URL that I am already using.

Re: Invoke-PowerBIRestMethod: $top parameter doesn't work when on Refresh history (GET /refreshes)

Anonymous — Mon, 13 Jun 2022 14:55:40 GMT

Yes, I have tested it and there is no problem

Re: Invoke-PowerBIRestMethod: $top parameter doesn't work when on Refresh history (GET /refreshes)

Anonymous — Tue, 14 Jun 2022 01:58:01 GMT

Re: Invoke-PowerBIRestMethod: $top parameter doesn't work when on Refresh history (GET /refreshes)

AEsquivel-AMPM — Thu, 23 Jun 2022 14:27:22 GMT

Hi @charlieswing , I found the solution; it is not a Power BI bug. The problem is when you add a $ in text using PowerShell it is interpreted as a variable; in other words, you have to escape the $ with `

$workspace_id = "your_workspace_id" $dataset_id = "your_dataset_id" $url_refresh_history = "https://api.powerbi.com/v1.0/myorg/groups/"+$workspace_id+"/datasets/"+$dataset_id+"/refreshes?`$top=2"