Forum Discussion
Power Query - Retaining Explorer Column Headings from a 'Music' folder file extraction
- For anyone else wanting to make a list of their music collection etc from folders within Microsoft then I was recommended to read this blog from Dutch Data Dude...
https://www.dutchdatadude.com/using-power-bi-to-visualize-your-music-collection/
It certainly worked a treat for me and gave me something to work on.
I hope it helps someone else.
Harveyworld
Harveyworld PQ doesn't look at the display settings in the Explorer. It just takes the data as it is stored on the disk. You'll need to extract and transform the data you need from what you see when you first connect to a folder. E.g. filter out all files that are not music files, remove all the date columns, split the "song - artist". And the album name is probably the part of the folder path. Not sure if and how you can extract track length. Don't have any music files on my machine so can't check.
Many thanks for your reply - I have to admit that I am somewhat distraught that this cannot be done from reading the file as is within Power Query. I had set up my folders using these default 'music' folder headings from Windows Explorer believing that MS Excel would be compatible with this format. After all its all Microsoft isn't it....
Given that I have hundreds of folders and thousands of music files which I would like to extract the detailed information in one huge table, does anyone else have any other ideas how to solve this issue with minimal pain? I am only after the listed file information in each of the folders but to go through each one separately would take a very long time.Thanks
- For anyone else wanting to make a list of their music collection etc from folders within Microsoft then I was recommended to read this blog from Dutch Data Dude...
https://www.dutchdatadude.com/using-power-bi-to-visualize-your-music-collection/
It certainly worked a treat for me and gave me something to work on.
I hope it helps someone else.
Harveyworld