22-25 April 2026 
Call Web APIs like a pro in Power Query
2022TL; DR
Topics: HTTP, REST, JSON, Paging, ODATA, Custom Functions + Authentication
Session Details
Today, a lot of data is in SAAS solutions in the cloud. Like SalesForce, Exact Online and Dynamics 365. To use this data in Power BI you need to connect to the data via a Web API (Web Service). This can be challenging if you have never done this before.
In this session I will show you step by step what to do and what pitfalls to avoid. The following topics will be covered:
- Introduction to Web APIs: JSON/XML data format, REST API
- Paging: often you can't get all the data at once and you have to call the Web API several times, page by page.
- Custom Functions in M: the building blocks of every Web API call
- Incremental Refresh: since fetching all data can be very slow via a Web API, it is better to only load new data.
- Authentication using API Token or OAuth (Access Token)
3 things you'll get out of this session
Speakers
Arthur Graus's previous sessions
Master Python in Fabric for Data Engineers
The world of data engineering is changing and being fluent in T-SQL is not enough anymore. In this full day workshop with lots of exercises you will get up to speed with Python and learn all the tips and tricks you need to know.
Python in Fabric for Data Engineers: all you need to know
The data engineering landscape is evolving. T-SQL proficiency isn't enough now. Dive into modern tools like Delta Lake, Jupyter Notebooks, and MS Fabric with Python. This session covers Python syntax, Jupyter in Fabric, data manipulation with Pandas, PySpark for Big Data, and data extraction/loading techniques for various formats.
Power Query formule language M for beginners
M is the formula language behind Power Query. Any transformation you apply to your data is translated into M code. Knowledge of this language opens doors that remain closed if you only use the GUI.