In this session, we’ll explore how to use REST APIs as data sources in Power BI. We’ll start with the essentials of working with Web.Contents() function and discuss the most common authentication methods used in API connections. You’ll also learn how to handle pagination effectively to retrieve large datasets. The session focuses on practical examples, including tips and tricks to optimize your queries. The session will revolve mostly around Power Query and its M language.