Were you able to figure out how to perform this function using Power BI? I have a very similar situation. Once I manually export the data, I am able to produce the information that I would like. But am also looking to do it more automated without the manual log onto the web site (the site I'm attempting to grab data from does not have three factor authentication). but otherwise, fairly similar process.