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