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

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
GoingIncognito
Advocate III
Advocate III

PowerShell refresh dataset

Hi.

I'm trying to use this to update a dataset in portal:

 

$User = "firstname.lastname@company.com"
$PW = "VerySecretivePassword"

$SecPasswd = ConvertTo-SecureString $PW -AsPlainText -Force
$myCred = New-Object System.Management.Automation.PSCredential($User,$SecPasswd)

Connect-PowerBIServiceAccount -Credential $myCred

$DataSetID = "XXXX-XXXX-XXXX-XXXX"
$WorkSpaceID = "XXXX-XXXX-XXXX-XXXX"

$RefreshDSURL = 'groups/' + $WorkSpaceID + '/datasets/' + $DataSetID + '/refreshes'
$MailFailureNotify = @{"notifyOption"="MailOnFailure"}
Invoke-PowerBIRestMethod -Url $RefreshDSURL -Method Post -Body $MailFailureNotify

 

But what I get back is:
Failed to get ADAL token: Unhandled Exception: System.AggregateException: One or more errors occurred. ---> Microsoft.IdentityModel.Clients.ActiveDirectory.AdalClaimChallengeException: AADSTS50076: Due to a configuration change made by your administrator, or because you moved to a new location, you must use multi-factor authentication to access [...]

Response status code does not indicate success: 400 (BadRequest)

 

Sure, we do use MFA but it pop-up only flashes quickly. What should I do about the ADAL token?
Thanks - a lot!

0 REPLIES 0

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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