Fabric Use case : Triggered dataset refresh

This is just a very simple use case for a data pipeline. First you will need a table from data engineering that shows the last time a table or view had been updated, for example view_name, last_updated, report.

Create a calculated column in a view that says that a given view belongs to a given report, for example the cost view belongs to the finance report. Create a view that checks if in the last 15 minutes you had an update, then we will use it in a data pipeline that we schedule to run every 15 minutes. Now add this view as a Lookup activity and connect an if else activity. Inside the if else activity check for every row if the report is finance then if it is true then add a semantic refresh activity. In case your model takes data from a dataflow first then add a dataflow refresh API call before that. You can add as many if else statements inside

Leave a Reply

Your email address will not be published. Required fields are marked *