Connect a workbook that changes name to a Power BI dataflow
I have a spreadsheet that is being located in a specific folder in Sharepoint. The content of the spreadsheet is every year exactly the same, however every year this spreadsheet is being re-created and saved with the same name but with different Financial year at the end.
What I have to do somehow is to create a dataflow using the spreadsheet but I want the dataflow every year to get the data from the new spreadsheet with the new financial year.
You could parse the year out of the filename to create a year column, and then use the Table.Max function to keep only the latest record/row (then extract the contents of that to get your updated data).