cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Clara Regular Visitor
Regular Visitor

Check 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 3
Super User
Super User

Re: Check which cells have been modified since last refresh

Hi @Clara

 

Currently as far as I know there is no way to check if cells have been modified in Power Query.

 

I think your method currently would be the best way possible to ensure that you are getting the right data.


Did I answer your question? Mark my post as a solution!

"Proud to be a Datanaut!"


Power BI Blog
Clara Regular Visitor
Regular Visitor

Re: Check which cells have been modified since last refresh

Thanks, @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?

Super User
Super User

Re: Check which cells have been modified since last refresh

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.

Did I answer your question? Mark my post as a solution!

"Proud to be a Datanaut!"


Power BI Blog