Please see the attached PowerBI file. I am trying to extract data from 01.01.2018 to 17.02.2021 from a website using link https://coinmarketcap.com/currencies/ethereum/historical-data/?start=20180101&end=EndDate. Sadly, I only get data extraction from 17.02.2021 to 18.12.2020 because further data is locked by a button called Load More.
How do I make Power Query to click the button a few times or to click it infinitely so I can get data from the range I selected?
Question 2.pbix (31.4 KB) !
Please see below the image with the button that is messing things up for me.