Get File path in Power query

[adityavighne]

Hi All,

i would like to get file path in colum in power query. How wold i get that?

my Table look like this:

Number | Name | File Path

1            | ABC    | 

2            | XYZ     | 

This data is appended from multiple tables so want to know file source 

[v-rzhou-msft · Accepted solution]

Hi @adityavighne ,

According to your statement, you have a table which is appended from multiple tables. Now you want to show your table with multiple tables' ID, Name and File Path.

As far as I know, if you want to append your tables, those tables must be loaded and export instead of show file path in Source step.

Here I have two workrounds.

1. Move all data source into one folder and than import data by Folder connector. You can combine tables by your requirement.

For reference:Combine files (binaries) in Power BI Desktop

2. You can see file path in Source step. So remove all steps in those tables and go back to Source Step. And append those tables.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.