Forum Discussion
Add column with folder name
I assume you are opening the files via the Combine operation and your query steps look something like this, where the items in the red square were created by Power Query automatically by the Combine operation:
Go to the "Removed Other Columns1" step, and click the little gear icon. Check the "Folder Path" box and hit OK.
Go to the end of your query steps and you'll have a new folder path column where those files are located. You can then use Text.Start, Text.Middle, Text.End, or whatever to create whatever text you want to combine with the folders.
Alvarom1 when you connect to sharepoint folder it has a column called Folder Path and you can use that to concatenate with file name
Would appreciate Kudos 🙂 if my solution helped.
HI thanks,
When I combined all the excel files with power bi I get a long list with all the lines from those excel. On that one, I do not have the path folder. What I need is , on that combined table, be able to add part of the text of the folder with each line(file) is coming from.
Makes sense?
Thanks
Alvaro
