(Livestream Replay) Connecting API's with Power Query - Not so Low Code? - with Erik Svensen

DESCRIPTION 📄

In this session Erik will demo how you can get data from web api's and how you can ensure that your model can be refreshed in the service.

We will by using real life examples walk through how to connect to different web api's and how different API's have different authentication methods that you will have to understand and master.

We will look at how you can parameterize your queries and only get the data for a specific period or other ways of specifying parameters that the API supports.

In the session you will also learn how to do a POST request to an API.

And YES we will spend a lot of the time in the Power Query Advanced editor.

After the session you should have a good start so that you can connect to the API's that are relevant for you.

GUEST BIO 👤

Erik Svensen is a Microsoft MVP. Erik has been working with the Microsoft BI stack for more than 20 years - starting with out with Excel and Microsoft Query for over 25 years ago. He owns the company CatMan Solution who is now serving over 70+ FMCG suppliers with a Power BI solution that provides the supplier with valuable insights in their performance at store level based on point of sales data provided to them by different retailers. He started the Danish Power BI User group and speaks at conferences and meetups. Another great passion besides Power BI is his collection of Danish contemporary art. And if he finds time he occasionally blogs about Power BI as well.

RELATED CONTENT 🔗

Erik's Blog
Erik's LinkedIn
Erik's Twitter
CatMan Solutions
Slide Deck Link

(Livestream Replay) Power BI REST API’s 101 & Useful Techniques - with Rui Romano

ABSTRACT 📝

This session aims to provide an overview of Power BI APIs with practical use cases to enhance your Power BI development experience. Tune in to learn more from one of the industry's best experts, Rui Romano!

GUEST BIO 👤

Rui is passionate about data and a frequent speaker on Microsoft events and user groups. He lives in Portugal and works as a Senior Program Manager @ Microsoft | Power BI CAT team.

RELATED CONTENT 🔗

Rui's GitHub
Rui's Twitter
Rui's LinkedIn

(Livestream Replay) Why Should I Be Interested in the ExecuteQueries Endpoint of PBI REST API? - with Štěpán Rešl

ABSTRACT 📝

At the end of last year, one called ExecuteQueries was added to the endpoint portfolio in the Power BI REST API. It is an endpoint that allows you to extract data directly from datasets. Although it also brings limitations, I think that its advantages outweigh them. So what can it be used for, and why should I be interested? Tune in to find out!

GUEST BIO- Štěpán Rešl 👤

"Don't say something cannot be done, or someone who doesn't know will come and do it.". This motto describes me very well. I would say because I am trying to find a path even on fields where paths shouldn't be. I'm the MVP of Data Platform (Power BI) and a co-founder of a company called DataBrothers, where I work as a Lead technical consultant. Primarily I am working with Microsoft Power Platform Technologies (Power BI, Flow / Automate, and PowerApps) and am the Author of the Czech PBI blog Jakna Power BI (translated "How to Power BI").

RELATED CONTENT 🔗

Štěpán's Twitter
Štěpán's LinkedIn
Tirnovar (github.com)
ReporTee (Power BI Guided Learning)

Calling the Power BI REST API with VS Code - with Mathias Thierbach

This talk introduces Visual Studio Code as a simple and convenient tool to access the Power BI REST APIs. Using the free "REST Client" extension, all aspects of the API can be used from within Visual Studio Code: Invocations can be saved for reuse, variables are supported, and API responses are available in full.

You will also learn about the different authentication types (service principal, interactive, admin), how those differ, and how they're configured.

All examples used in the recording and further notes are available here.

Note that this approach is also substantially faster then the "Try It" button integrated into Microsoft's official API docs here.

GUEST BIO 👤

In 2015, after having spent over ten years as a Software Developer and Architect with Microsoft technologies, Mathias Thierbach moved into the Microsoft BI space. He soon landed on Power BI, but also realized quickly that the development and engineering tools and practices were nothing like the ones well established in software development. This is how pbi-tools started as a project, filling this gap in tooling. Today, leading a growing data management team at YouGov, he experiences the benefits of those efforts every day. Having open sourced the project in fall of 2021, Mathias spends a lot of his free time bringing those practices to the wider Power BI community now.

RELATED CONTENT 🔗

Microsoft API Docs
Mathias’s API VS Code Samples
Mathia’s Notes/Articles
Mathias's Twitter
Mathias's LinkedIn
Mathias's GitHub