This script fails consistently when i run it under a SQL Job

[dmayi]

I am able to run this script successfully on Powershell console. But my use case is to run this from a SQL job for a scheduled refresh of my PowerBI report. That is not working for me. Any hints please? Thanks

[richardlhughes]

Try running in CmdExec

@command=N'powershell.exe -ExecutionPolicy Bypass -Command "Import-Module ...

Maybe this will help.
https://www.sqlhammer.com/running-powershell-in-a-sql-agent-job/