I have a Semantic Model that has implemented Incremental Refresh.
I want to create a .ps script to set him to run each week.
At this moment my script want to run just incremental and I can’t do it to run in full and I don`t understand why.
Anyone has any ideea?
- Part of the script:
# FULL REFRESH
Write-Host "Starting refresh operation"
# Check if the dataset exists in workspace
if ( Get-PowerBIDataset -WorkspaceId $filteredWorkspaceId -Name $filteredWorkspaceName) {
$header =
'{
"refresh": {
"type": "full",
"applyRefreshPolicy": false,
"commitMode": "transactional",
"maxParallelism": 8,
"retryCount": 2
}
}'
# If the dataset exists, trigger the refresh
$refreshSemanticModelDEV = Invoke-PowerBIRestMethod -Url $urlGroups -Body ($header) -Method POST -Verbose -WarningAction Ignore
$refreshSemanticModelDEV
#$refreshHystory = Invoke-PowerBIRestMethod -Method GET -Url $urlGroups -WarningAction Ignore -Body ($header)
#$refreshHystory
}
else
{
# If the dataset does not exist, display an error message
Write-Host "Dataset does not exist in " $filteredWorkspaceName
}
New contributor
Vicentiu Stefan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.