I was trying to grab data from a single URL with multipage data, using GetData from Web. Somehow, it only managed to grab the 1st page of data. Then I switched to Excel PowerQuery, using the same method. This method successfully grab all pages of data. Why is this so?
Is there a setting in PowerBI that I can set to grab all pages, and not just the 1st page?regards,
JW