Forum Discussion
Import Video files with Power Query into Excel including additional properties such as Length
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!
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!
2 Replies
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.
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!
