Powershell Script to Update Dataset Not Working

[gustavofill]

Hey guys!

I created this script based on some tutorials to update the dataset.

However, it works sometimes, not always. Below I will put the script and the error it presents around 80% of the time.

$User = "your-email"
$PW = "your-password"

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

Connect-PowerBIServiceAccount -Credential $myCred

$DSIDRefresh = "XXXX-XXXX-XXXX-XXXX"

$WSIDAdmin = "XXXX-XXXX-XXXX-XXXX"

$RefreshDSURL = 'groups/' + $WSIDAdmin + '/datasets/' + $DSIDRefresh + '/refreshes'

Invoke-PowerBIRestMethod -Url $RefreshDSURL -Method Post

Hope someone can help me, this script would help a lot.

[Hariharan_R]

Hi @gustavofill 

Added the code reference. Hope it will be useful!!

Ref - https://technovert.com/blog/refreshing-all-datasets-in-power-bi-using-rest-api/

Thanks

Hari

Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.

My Blog :: YouTube Channel :: My Linkedin