Hello, I just discovered power query and thought I understood it fairly well but I don't. I have attached a pdf of a windows folder (temp locn for mp3 folder song list) that I have on my laptop that contains some MP3 files. (see attached pdf titled "windows folder with name and windows attributes" ) As you can see, there are 2 windows attributes, Album, which contains the author of the song, and Name, which contains the title of the song.

When I do an excel power query and open this folder, power query presents an edit page that does not have these 2 attributes on it. Not only that, but it has other file attributes that I have not asked for but they seem to have been imported into the query The file attributes that power query collected for me were content,name,extension, date accessed, date created, date modified, attributes, and folder path. (See attached pdf titled "output of power query editor") I didn't want any of these in the report, I only wanted author and name!

Am I missing a step in the setup? How do I make power query import the folder and file attributes to my spreadheet that I am intereted in seeing and editing? Thanks

Attached Files

	windows folder with name and album attributes.pdf (23.4 KB, 6 views)
	output of power query editor.pdf (77.3 KB, 4 views)