Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
16 | |
2 | |
2 | |
1 | |
1 |