Working with API data is often a task reserved for pro-coders. But in Microsoft Fabric, we can leverage the low-code Dataflows Gen2 to connect to any API and output the data to our Fabric Data Lakehouse or Data Warehouse.

This is a very attractive solution to all Fabric users who are coming from a Power BI background and already now Power Query, or to those who feel Notebooks seem a little daunting.

This session will use the STRAVA API as a starting point to teach you about the following three key techniques for working with APIs in Dataflows Gen2:

- How to use GET requests to download data from APIs.
- How to use POST requests to pass data, such as authentication parameters, back to the API.
- How to work with dynamic schemas and pagination, for more advanced API work.

After the session, you should feel confident exploring your own API use cases, and know the techniques needed to get the most out of your data.