Pulling Any System Attribute from Files RRS feed

  • Question

  • I am very new to Power Query in Excel. I wanted to try and create a file that could automatically pull all of the following info from a movie file, show it in their respective columns, and easily refresh if I make changes (don't need it to auto-refresh)...

    • Filename
    • Type
    • Size
    • Length
    • Total bitrate
    • Frame width
    • Frame height
    • Video tracks
    • Audio tracks
    • Subtitle tracks

    I know their are movie databases out there that do these things, but I wanted to try and build my own simple database to help learn coding, and I haven't found a movie database I really like. I have been able to add Size as an attribute, but I'm not sure how to add any other system attributes that aren't already in PQ's Attribute column.

    Sunday, July 14, 2019 6:26 PM