Forum Discussion
Progress Tracker Update via Power Query
Seems simple enough but I cannot figure out how to implement. I created a new spreadsheet and recreated the power query beginning with a sort on the source files by date created. Now it adds rows from each file sequentially rather than updating the rows from the first file with each updated file.
Any tips on that?
rather than updating the rows from the first file with each updated file.eh? I may have misunderstood what you are ultimately trying to achieve. Do you want to ingest only the latest file, or do you expect to be able to modify existing dataset data with information from the latest file?
Power BI has no memory* . You need to manage your snapshots in the upstream system.
* Yes, there is the self referencing option but that has no safety net.
Every week I get an updated file with a new updated completion percentage for every activity. I thought I could use power query to automatically pull that new percentage from the latest file and update my spreadsheet so that I could just throw each new file into the data source folder each week.
Does that make it any clearer?