cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

Schedule a data refresh

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.

 

Thanks.

 

2 REPLIES 2
Highlighted
Resolver I
Resolver I

Re: Schedule a data refresh

HI.

 

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.

 

Regards

Andris

Highlighted
Anonymous
Not applicable

Re: Schedule a data refresh

OK thanks not totally ideal I think.

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.

Helpful resources

Announcements
May 2020 Community Highlights

May 2020 Community Highlights

It’s time for another PBI Community recap!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Top Solution Authors
Top Kudoed Authors