Refresh a dataset when your data load finishes

import time
from clickruntime import on_event, credentials, http, notify

GROUP_ID = "0f1e2d3c-4b5a-6978-8796-a5b4c3d2e1f0"  # Sales Reporting
DATASET_ID = "cfafbeb1-8037-4d0c-896e-a46fb27ff229"  # Sales
URL = f"https://api.powerbi.com/v1.0/myorg/groups/{GROUP_ID}/datasets/{DATASET_ID}/refreshes"

@on_event
def handle(event):
    headers = {"Authorization": f"Bearer {credentials.connection('power-bi', 'work')}"}
    resp = http.post(URL, headers=headers, json={"notifyOption": "NoNotification"})
    if resp.status_code != 202:
        notify.email_me("Sales refresh could not start", resp.text[:1000])
        return {"started": False}
    for _ in range(40):  # check every 20 s for up to ~13 minutes
        time.sleep(20)
        last = http.get(URL, params={"$top": 1}, headers=headers).json()["value"][0]
        if last["status"] in ("Completed", "Failed"):
            notify.email_me(f"Sales refresh {last['status'].lower()}",
                            f"Finished at {last.get('endTime')}\n{last.get('serviceExceptionJson', '')}")
            return {"status": last["status"]}
    notify.email_me("Sales refresh still running", "It started but hadn't finished after 13 minutes.")
    return {"status": "Unknown"}