Getting the right data is often the most challenging part of any analytics project. Whether it’s locked away in a CRM, HR platform, or ERP system, accessing the right data is the first step to delivering real business value.

As an experienced Data Engineer or Power BI developer exploring the immense capabilities of Microsoft Fabric, you’re likely already familiar with Dataflow Gen2, which uses the same powerful Power Query you know and love from Power BI. But did you know you're not limited to the built-in connectors? With a bit of knowledge about APIs and just one function in Power Query, you can connect to almost any data source and pull in exactly the data you need - securely, efficiently, and automatically.

In this session, you’ll learn how to use the Web.Contents() function within Dataflows Gen2 to unlock access to external data sources. We’ll demystify key API concepts like bearer tokens, pagination, and rate limits, making them approachable and easy to handle.

Through hands-on demos from real-world cases, we’ll walk through the process of connecting to APIs step-by-step, starting with a simple public API, then moving to token-based authentication, and completing the journey by creating Power Query functions to deal with API pagination and rate limits.

By the end of this session, you’ll be empowered to go beyond the standard connectors and confidently bring any API data into your Microsoft Fabric environment to populate your Lakehouse and Data Warehouse or immediately unlock insights within Power BI.

Join me to empower your data projects like never before!

Target audience: Power BI developers and Data Engineers familiar with Power Query but new to APIs