Power Query from web (Stathead.com)

[tinderbox22]

Hi. I've been attempting to set up a Power Query to scrape stathead.com's data tables. It worked fine until Stathead changed to a paywall. So, I now I have to sign in with new credentials. In setting up a new query, I've tried to adjust the Data Source Settings to accommodate my new login credentials. However, it still scrapes the "free" version of the page, which of course is incomplete data. If I'm on the web and signed in, I get exactly what I'm looking for. But my Power Query does not allow me to scrape the data into excel. Is there something I need to do in the code to account for my login credentials?

 

[Matt Allington]

To the best of my knowledge, PQ does not support scraping behind a paywall. It can use APIs with credentials but not web pages. The way I have done this in the past is to use Python, but that’s a whole new world. ChatGPT may be able to help