Display Row Changed Time in Report from prevois hour

[Anonymous]

Hello,

I have a table in PowerBI report, I want to create a coulmn at the start of table which will show if the row (record) has been updated in last hour or not.

I am using import mode but I will use DQ in next update of the report.

One solution I had in my mind was to create a data flow with data source and Create report with Direct Query (I am always displaying latest data) with page auto refresh. Then I will refresh Dataflow every hour and use that dataflow in my report and compare it with my Direct Query table for each row, if there is any change then flag it.

Is there a better way? Please guide me on this.

[v-lili6-msft]

hi  @Anonymous 

To my knowledge, it could not achieve in power bi for now, since power bi won't store old data after refresh, so you couldn't compare current data with old data to see if the row (record) has been updated in last hour or not.

Regards,

Lin