Forum Discussion
Solved
Power Query - Retaining Explorer Column Headings from a 'Music' folder file extraction
Hello, I am relatively new to Power Query and seem to be doing OK, but at the moment I have hit a huge hurdle which is stumping me. Any assistance would be hugely appreciated. Currently, I ha...
- 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
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
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