Power BI and Plex for Windows

I am trying to connect my Plex system to Power BI so I can run data analysis on the files and figure out dups etc . I am running Windows 10. If there is already a thread please post the link as I could not find it anywhere.

Thanks

Ok Found the answer here
HOW TO: Use SQLite as a Power BI Data Source – Proving Ground Apps

  1. install SQLite connector
  2. DB is \AppData\Local\Plex Media Server\Plug-in Support\Databases\com.plexapp.plugins.library.db
    power Bi loaded it just fine… now the fun begins!