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