PowerBI Automated Refresh

KMaggs

We know how to schedule workflows to run automatically. However, once the subsequent snapshots have been produced, is there a way to notify PowerBI that the data has been updated? Currently the PowerBI developer is having to refresh the datasets manually once they know the job has completed as per the schedule.

Josh Boxer

Hello

You can check the status of the schedule using the API https://docs.experianaperture.io/data-quality/aperture-data-studio-v2/extend-data-studio-functionality/use-the-rest-api/#run-and-manage-schedules

Might be easier to just schedule PowerBI to update the dataset every few hours to pick up any changes

Note you can import the data using Odata of not already doing this

https://community.experianaperture.io/discussion/597/%EF%BB%BF-%E2%84%B9%EF%B8%8F-%EF%BB%BF-importing-your-datasets-into-excel-or-tableau-using-odata

Finally, it looks like PowerBI has an API that could be called to refresh the data https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/refresh-dataset might be able to call this using Power Automate or similar tool if you have access