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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
jvanrossum
New Member

PowerShell Rest API refreshSchedule - Response status code does not indicate success: 400

When I use PowerShell (via DevOps) to call the refreshSchedule operation it fails:
Messages - One or more errors occurred.
Inner Exception - Response status code does not indicate success: 400 (Bad Request).

# Create credentials for Service Principal
$ServicePrincipalCredentials = New-Object System.Management.Automation.PSCredential ($ApplicationId, (convertto-securestring $ClientSecret -asplaintext -force))

# Login to Power BI
Connect-PowerBIServiceAccount -Credential $ServicePrincipalCredentials `
                              -Tenant $TenantId `
                              -Environment Public `
                              -ServicePrincipal 

# Example schedule
[string]$body =  "{""value"":{""times"":[""16:00""],""Enabled"":""true""}}"

# Construct Rest API URL
[string]$Url = "groups/$($WorkspaceId)/datasets/$($dataset.id)/refreshSchedule"

# Call Rest API
Invoke-PowerBIRestMethod -Url $Url -Method Patch -ContentType "application/json" -Body $body

When I print the variables to the screen and copy and paste them in the Try It section of the documentation it always works without errors. Tried serveral ways to construct the body (different messages, different string constructions). Before this Rest API call I have at least a dozen other PBI Rest API call and they all work without errors.... Any suggestions?

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Unfortunately is seems that a Service Principal cannot perform this action. You need a Service Account (AAD account) for this.

View solution in original post

3 REPLIES 3
v-stephen-msft
Community Support
Community Support

Hi @jvanrossum ,

 

Please refer to this post:

400 Bad Request Error when embedding report

 

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thanks for the reply, but I'm not sure how that post helps solving my problem. They have the same general error message, but that problem is about embedded.

Anonymous
Not applicable

Unfortunately is seems that a Service Principal cannot perform this action. You need a Service Account (AAD account) for this.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

November Carousel

Fabric Community Update - November 2024

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

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.