Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
charlieswing
Microsoft Employee
Microsoft Employee

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

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.

1 ACCEPTED SOLUTION
AEsquivel-AMPM
New Member

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"

 

View solution in original post

5 REPLIES 5
AEsquivel-AMPM
New Member

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"

 

Anonymous
Not applicable

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

Anonymous
Not applicable

GSun_0-1655171755451.png

GSun_1-1655171871679.png

 

Anonymous
Not applicable

Yes, I have tested it and there is no problem

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.