tl;dr pagination is a form of dividing data into smaller chunks (pages). With this method we can achieve more efficient transfer of data....

tl;dr API is way how two apps communicate with each other. Using M's Web.Contents(), Json.Document() features, we can utilize this in Power Query, here's how to do it. Story Have you ever been a little bummed because your favourite application didn’t have a native connector inside Power BI Desktop? So you’re stuck manually downloading files to Excel, saving them on an on-premises shared drive or SharePoint folder (in the better  scenario). Meanwhile, your developer and data e