Webpage scrape issue beyond the landing page

Anonymous · ‎09-30-2020

Hi all i am struggling to scrape data from Microsoft Exam Certifications site. I can scrape data from the loading page (30records) "https://docs.microsoft.com/en-us/learn/certifications/browse/". However I want to be able to scrape all the records (currently 248) ie. "https://docs.microsoft.com/en-us/learn/certifications/browse/?skip=240". Any asssitance woud be much appreicated.

CNENFRNL · ‎10-01-2020

Hi, @Anonymous , I think you might want to refer to another thread for a possible solution,

https://community.powerbi.com/t5/Power-Query/M-query-combining-multuiple-tables-of-the-same-sturcture/m-p/1406060#M43976

Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension!

DAX is simple, but NOT EASY!