Refresh Power BI Report Server Dataset with Powershell and SQL Agent

• david_h_edmonds

  Default port

  Points: 1430

  More actions

  February 22, 2021 at 2:49 pm

  #3848515

  Hi, I have had the below script running for approx 12 months and after a power BI Upgrade on Friday last, it has stopped working.

  I can manually work around it but it would be nice to get it working again.

  Current PowerBI Report Server version: Version 1.10.7698.27886 (January 2021).

  The error is "The remote server returned an error: (403) Forbidden."

  Does anyone have any ideas?

   

  Cheers,

  Dave

  $id = "************************ removed for security**********************"
  
  $URL = "http://server1/Reports/api/v2.0/CacheRefreshPlans(" + $id + ")/Model.Execute"
  
  #Write-Output $URL
  
  $MailFailureNotify = @{"notifyOption"="MailOnFailure"}
  
  Invoke-WebRequest -Uri $URL -Method Post -Body $MailFailureNotify -UseDefaultCredentials -UseBasicParsing
  
  

  • This topic was modified 3 years, 10 months ago by  david_h_edmonds.
  • This topic was modified 3 years, 10 months ago by  david_h_edmonds.

• Phil Parkin

  SSC Guru

  Points: 246980

  More actions

  February 22, 2021 at 2:59 pm

  #3848521

  403 is an HTTP error. Perhaps HTTPS is now being enforced?

  The absence of evidence is not evidence of absence.
  Martin Rees

  You can lead a horse to water, but a pencil must be lead.
  Stan Laurel

• david_h_edmonds

  Default port

  Points: 1430

  More actions

  February 22, 2021 at 4:05 pm

  #3848572

  Hiya Phil, I tried that but no luck.

  it’s worth mentioning that other scripts using the same method are unaffected.

  cheers,

  Dave