How we can implement loop check if data has been loaded in the table for latest required data.

[PrashanthG]

How we can implement loop check if data has been loaded in the table for latest required data and then refresh the dashboard otherwise do nothing.
If data has not been loaded by specific time e.g. 9 AM UKT, send failure notification to business user.
If dashboard is refreshed with latest date data, then also inform user with successful notification.

Can we implement this in Power BI?

[Shaurya · Accepted solution]

Hi @PrashanthG,

If you want to refresh the dataset to load only the newly added data, you can setup Incremental Refreshes. Here's a link for your reference:

https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview

You can use subscriptions to get updates about your report:

https://learn.microsoft.com/en-us/power-bi/consumer/end-user-subscribe?tabs=creator

Works for you? Mark this post as a solution if it does!
Check out this blog of mine: How to Export Telemetry Data from Azure IoT Central into Power BI