Forum Discussion
Upload Most Recent/Last Sheet Only In Excel Workbook
Hello,
Is there any way to automatically have the PowerBI data show only the last sheet in a workbook? For example, I have 5 sheets in an excel workbook. I want to automatically have the last sheet (sheet 5) uploaded as my data, automatically. Is there a way to do that? Thank you!
Anonymous then it should be straight forward, once you connected to excel file,
- go to source step
- add new column from name and change its' data type to date (basically create date column from name column)
- sort on this column in ascending order
- keep first row (it will remove all other sheets and most recent sheet based on the date will be the only row)
now expand the data column and that will do it.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡
3 Replies
Anonymous is it always sheet5 or this workbook growing and there will be new sheets in the future? if yes, does the new sheet will always have incremental number, like sheet6, sheet 7 etc?
Anonymous then it should be straight forward, once you connected to excel file,
- go to source step
- add new column from name and change its' data type to date (basically create date column from name column)
- sort on this column in ascending order
- keep first row (it will remove all other sheets and most recent sheet based on the date will be the only row)
now expand the data column and that will do it.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡