Forum Discussion
Progress Tracker Update via Power Query
Super User I considered that power query might not know which file is the most recent fileExactly. Power Query does not guarantee a sort order. You will need to bring your own sort order. In your case you would add a step that sorts by file creation date descending, and then grabs the data from the first file (row 0).
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?
- lbendlin
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?
