Is it possible to dynamically build a history table over time?

[Anonymous]

In my Power BI report, I'm pulling in two tables:

1) Postings from an Application Tracking System

2) Posting on the actual Careers Site (via XML feed).

I have it set up so that when the Application Tracking System indicates a posting should be live, but it's not on the Careers Site, I get sent a Data Alert. This all works great and the data is refreshed hourly so that I can respond to issues with syncronizing the careers site with our ATS.

The problem is that sometimes I don't get around to addressing the data alert, and by the time I do, the alert is gone (data has refreshed and the issue is no longer present).

I'm trying to think of a way to essentially "get the row" that caused the data alert, and store it for future reference. I went down the path of Microsoft Flows, but there's no way to "get row" from a Power BI Dataset. Is there a way to do this within power itself? Like, a query that gets the rows whenever it is refreshed?

[v-jiascu-msft]

Hi @Anonymous ,

Since the tiles that support alert are aggregating data, I'm afraid it's hard to locate the rows. Please refer to service-set-data-alerts. BTW, if there isn't an alert in the new data, does that mean the error is gone?

Best Regards,