Get last refresh date time for each partition

Hi  sergprim ,

How about this: 

# Parameters
$groupId = "<your group ID>"
$datasetId = "<your dataset ID>"
$accessToken = "<your access token>"

# Base URI for Power BI REST API
$baseUri = "https://api.powerbi.com/v1.0/myorg"

# Get dataset metadata
$datasetUri = "$baseUri/groups/$groupId/datasets/$dataSetId"
$datasetMetadata = Invoke-RestMethod -Uri $datasetUri -Headers @{ "Authorization" = "Bearer $accessToken" }

# Get partition metadata
$partitionsUri = "$baseUri/groups/$groupId/datasets/$dataSetId/partitions"
$partitionsMetadata = Invoke-RestMethod -Uri $partitionsUri -Headers @{ "Authorization" = "Bearer $accessToken" }

# Loop through partitions and get latest refresh date time
foreach ($partition in $partitionsMetadata.value) {
    $partitionMetadataUri = "$baseUri/groups/$groupId/datasets/$dataSetId/partitions/$($partition.id)/metadata"
    $partitionMetadata = Invoke-RestMethod -Uri $partitionMetadataUri -Headers @{ "Authorization" = "Bearer $accessToken" }
    $latestRefresh = $partitionMetadata.refreshHistory.refreshes | Select-Object -First 1
    Write-Output "Partition $($partition.name) - Latest refresh: $($latestRefresh.startTime)"
}

Let me know if this helps 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

sergprim