Ah... Yes. So SharePoint lists are becoming a lot cooler. With the addition of MS Flow and a Data Gateway, you can do some really interesting stuff.
For SharePoint lists in Power BI... A list is essentially 2 elements, a list and a library. So by placing the filename in the list, then using the get from SharePoint folder, you can then join the list to the attached data... Plus, one of my favourite tricks. As you can enter your own columns in SharePoint, you can then make a list filter the files that are passed to Power BI.
As far as SharePoint goes, it gets a bad rep but it's getting much better. JSON column formatting is also good if you have found that yet.
HR is a cool area for digitalisation... Seems to all be moving to online interviews, I had to do a test for it due to my skillset. They can then use all sorts of analysis. Horrid experience though