Our data is often hidden behind some API, and we have to get it out to make a report. But we can encounter many obstacles along the way. One such "obstacle" is putting the obtained data into a table at all, solving pagination, and then how to solve Dynamic Datasource or how to prevent it altogether. In addition, it is necessary to know that the API may ask us for various other elements in the header or HTTP Query.

But don't worry! It's not rocket science. Together, we'll introduce the necessary concepts to understand both inside Power Query and from the perspective of the API as such, and I'll show you that pulling data from the API is quite simple.