Forum Discussion
Add column with the path&filename
Good day, I'm trying to add a column containing the folder & filename for each row of the dataset being imported . I've tried this but does not return want I want.... = Table.AddColumn(#"Sales"...
Hi DanFromMontreal ,
Check this out: Solved: adding the file name to a column in power query - Microsoft Power BI Community
This similar post is using the Sharepoint Folder Connector to connect to a OneDrive for Business site and use combine files feature after getting a file list in the folder you want to connect to. But edit or add some steps in the process.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.