Forum Discussion
Advocate IICheck which cells have been modified since last refresh
Hello!
My company has multiple Excel files which are modified by different people every month. Each month there should be new data for the previous month's (let's say) sales, but none of the months and years before should have any changes. I say should, but of course every once in a while somebody randomly alters some old data and tells us nothing about it.
Is there any way I can use Power BI for checking if cells have been altered since my last (auto)refresh -- and if yes, mark these cells out for me?
My initial idea is duplicating my query and letting just one of them update while the other remains static (unless I manually refresh it), and comparing the two in a report. Is this possible? Is there a more efficient solution?
3 Replies
ClaraThanks, GilbertQ!
But by this:
My initial idea is duplicating my query and letting just one of them update while the other remains static (unless I manually refresh it), and comparing the two in a report.
What I mean is, does Service let me do that? Keeping one query static and another one dynamic in a same dataset, while refreshing automatically every day? Or would it only be possible to do manually on Desktop?
- GilbertQ
Super User
Hi there
Currently when you refresh a Power BI model, it will refresh all the tables that are marked with "Include in Report Refresh" as well as if a table is used as a reference or duplicate table, it too will also refresh.
Whilst you can leave one query static, if it is referencing each other they both will be refreshed.
