cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
qubit813
Post Partisan
Post Partisan

how to schedule dataset refresh by a dependency outside of PBI

Is it possible to schedule a dataset refresh by a dependency on something outside of PBI?  For example, I have a dataset that I don't want refreshed until a certain SQL job runs.  That SQL job usually runs on Monday afternoons.  But, it could run on Tuesday.  However, in the PBI service, I only have options for daily or weekly refreshes.  So, currently, as my workaround, I have the report refresh daily.

1 ACCEPTED SOLUTION
GilbertQ
Super User
Super User

Hi @qubit813 

 

You could do this by using the Power BI REST API which you can call to refresh a dataset.

 

I actually use Power Automate these days where I look for a specific email from my SQL Server when the job completes. When I receive this email Power Automate then refreshes the dataset.

 

Refresh your Power BI dataset using Microsoft Flow | Microsoft Power BI Blog | Microsoft Power BI





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

1 REPLY 1
GilbertQ
Super User
Super User

Hi @qubit813 

 

You could do this by using the Power BI REST API which you can call to refresh a dataset.

 

I actually use Power Automate these days where I look for a specific email from my SQL Server when the job completes. When I receive this email Power Automate then refreshes the dataset.

 

Refresh your Power BI dataset using Microsoft Flow | Microsoft Power BI Blog | Microsoft Power BI





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!