Unable to access SP file names using SharePoint.Contents over SharePoint.Files

[GulianiG]

The query below is to access the right SharePoint folder

The problem I am having is in another referenced query named "Emp_Snapshot_Dim" I am not able to access file names
It is only showing sub-folders as name- not actual file names within the sub-folders
How can I get file names because I need to extract the date from file name

Thanks, I can come on a screen share with anyone willing to help- thanks

[GulianiG]

Thanks @lbendlin 
As advised, I just had to click the expland icon on Content and I got all the file names

Can you help with a related question?
https://community.fabric.microsoft.com/t5/Power-Query/SharePoint-Contents-vs-SharePoint-Files/m-p/34...

[lbendlin · Accepted solution]

With SharePoint.Contents you need to do the navigation yourself. It will not automatically include all the names from all the files in all the subfolders the way Sharepoint.Files does it.