Help with setting up the path

[Just2431]

Hello!

I am totally new to the Power Bi but I have hard time to set this up..so..I have a folder with a one excel workbook, I imported this workbook (1 sheet) to the Power Bi and before I start tranforming, shaping the data and creating a report, I wouls like to create and set up the correct path so that every week, month when I add a new sheet to that folder (it will be added every 3 weeks), I will be able to open the report , click refresh and all the new sheets will be automatically transformed and added to my report.  Can someone help me with this please?

I hope this is easy to follow. Thank you in advance!

[Just2431]

Thank you!

[amitchandak · Accepted solution]

@Just2431 , You can use folder

https://addendanalytics.com/blog/import-multiple-excel-files-in-power-bi-tips-tricks

Latest version of file

https://exceleratorbi.com.au/load-the-latest-version-of-a-file-in-power-query/