Import Video files with Power Query into Excel including additional properties such as Length

[fab_1007]

Hello,

I would like to make a list of videos (mp4) in Excel from levels of folders and subfolders using the Power Query. Is there an option to include more properties than "extension", "Date accessed", "Date modified" etc.? I'm specifically looking to import the length of each video clip.

Many thanks!

[Anonymous · Accepted solution]

Hi @fab_1007 

Thanks to @lbendlin for the information. I tested with Folder connector, the result looks similar, without the video duration information. 

To get the duration of video files, you may need to use other tools like PowerShell/Python/C# scripts or some third-party tools and export the data into text/csv/excel files. Then use Power BI to connect to the exported files. Some references:

shell script - Get total duration of video files in a directory - Unix & Linux Stack Exchange

command line - How to check how long a video (mp4) is using the shell? - Ask Ubuntu

How to get the duration of a video in Python? - Stack Overflow

c# - How to get video duration from mp4, wmv, flv, mov videos - Stack Overflow

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

[lbendlin]

Are you using a File Folder connection or a SharePoint Folder connection?

On a SharePoint Folder you can only get the size information, it seems.