This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowA new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.
I use this API to automatically refresh a dataset via a Powershell script with a Service Principal, however when I run the script I get this error in the dataset.
Do you know why?
My script :
$IDWKS = Get-PowerBIWorkspace -Name 'WKS - [REC] FINANCE'
$IDDTS = Get-PowerBIDataset -WorkspaceId $IDWKS.Id
Invoke-PowerBIRestMethod -Url "https://api.powerbi.com/v1.0/myorg/groups/$($IDWKS.Id)/datasets/$($IDDTS.Id)/refreshes" -Method POST -Body ('$($IDDTS.Id)')
Do exactly as the error message says. Refresh the credentials in the dataset settings page. Credentials do expire, service principal or not.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.