The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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.