topic Re: Schedule PowerShell Scripts in Cloud in Developer

Schedule PowerShell Scripts in Cloud

pvuppala — Fri, 24 Jun 2022 22:29:15 GMT

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

Re: Schedule PowerShell Scripts in Cloud

Hariharan_R — Mon, 27 Jun 2022 05:01:57 GMT

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

Re: Schedule PowerShell Scripts in Cloud

pvuppala — Mon, 27 Jun 2022 14:18:55 GMT

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.