Hi, i would like to schedule a refresh of the data but through another scheduling software. I can see you can schedule a refresh but can't see an option to run via dos powershell command which will be the option here i think. Also i noticed You can also trigger a data refresh programmatically by using the Power BI REST API but just want to do it via DOS/ powershell or similar.
Data refresh is actually done by SQL Server agent job - when you create refresh task in Report Manager, new SQL Server job is created. So, to trigger a refresh, you can start this job via PowerShell, for example.
Do you know if there any errors coming back from the SQL Agent will it be reported back ok to the calling process. Also when the scheduled proceess runs it may have to wait for the Agent to finish executing. Do you know if that works ok.
I was hoping that i can call an executable to run the job, calling the SQL Agent may just do things in the background which is not my requirement? Thank you.