List of Connected data sources

[Amardeep100115]

How we can have table in power query with all data sources details like 

File NAme and File date

Please help

[edhans · Accepted solution]

If you got your data by the File|Combine operation in Power Query, go to the "Removed Other Columns1" step that the combine opreation did.

1. Press the gear icon
2. Check the Source.Name and Date Modified fields.

If you are getting your data some other way though you cannot do that within Power Query itelf. The queries don't know properties about themselves.

You might see if Monkey Tools can help. It is a 3rd party app that does some cool stuff with Power Query, but don't know if it can extract that type of info and put into the data model for you.

[amitchandak]

@Amardeep100115 , refer if these can help

https://www.sqlservercentral.com/blogs/include-file-name-in-content-using-power-query

https://www.youtube.com/watch?v=MlAGK90EKL8