Schedule PowerShell Scripts in Cloud

[pvuppala]

Hey Gurus,

So I have a PowerShell script that use Power BI commandlets for admin tasks.  I run it manually every week and it basically moves all new "Personal Workspaces" to an embedded capacity which is paused (essentially disabling all personal workspaces).  I'd like to look at automating this execution on a schedule by not tying up to my local desktop or any of our team.    I'm reading it can be done using these two methods.  Please advise whats the path of least pain.

• Azure Run books
• Power AUtomate + Custom Connector

Thanks in advance!

-Pawan

[pvuppala]

Thank you Hari, it sounds like we need to type in our password in clear text for this to work?  If so, that is not fly at our Org. Please advise.

[Hariharan_R]

Hi @pvuppala 

If you make your PowerShell scripts to run without entering pop up credentials then you can use it in Azure Runbooks.

Ref - https://dataap.org/blog/2019/12/04/power-bi-rest-api-in-powershell-with-no-user-credentials-pop-up/

Ref - https://docs.microsoft.com/en-us/azure/automation/learn/powershell-runbook-managed-identity

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