(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 CI/CD, the REST API, and VSCode - with Gerhard Brueckl

DESCRIPTION 📄

Since its release in 2015, Power BI has quickly become one of the major and widest spread reporting tools on the market. It is used for self-service BI, team BI and also enterprise BI solution of which especially the latest has very specific requirements when it comes to managing deployments and releases. We would like to discuss the typical use-cases and problems that you will encounter when trying to use the traditional approaches for CI/CD and release management with Power BI.

GUEST BIO 👤

Gerhard is a data solution architect at Paiqo GmbH in Austria. He has been working with Microsoft Data & BI tools for over 15 years and is still continuously learning. In all those years he was always shared his knowledge with the community in forums, his personal blog or when speaking at conferences or user groups. Over the last years he focused more on big data and cloud processing in Microsoft Azure but always maintained the link to his roots in BI.

RELATED CONTENT 🔗

Twitter
Blog
LinkedIn
GitHub

[DAX] Dynamic Format Strings WITHOUT Calculation Groups ?!?

Video by: Reid Havens

Learn how to add Dynamic Format Strings for individual [DAX] measures in Power BI! This technique doesn’t require calculation groups or Tabular Editor either, and can be done entirely inside of Power BI desktop.

Side note, if you aren’t using Tabular Editor as a model developer you should be. It’s a fantastic tool for any intermediate to advanced modeling scenarios, and the only way to add calculation groups (today).

RELATED CONTENT 🔗

Dynamic Format Strings in DAX
Kane Snyder’s Linkedin Post
Tabular Editor

(Livestream Replay) Empower BI Professionals to Do More Using Microsoft Fabric - with Christian Wade

ABSTRACT 📄

As the volume and complexity of data continue to increase, organizations are constantly looking to uncover insights in faster ways. Join us to learn about Power BI’s exciting new announcements that enable data professionals to gather insights at blazing fast speeds with Microsoft Fabric.

GUEST BIO 👤

As Principal Group Product Manager in the Power BI group, Christian manages a team of program managers responsible for enterprise modeling features across Microsoft's BI product portfolio. He drives product strategy, feature prioritization, planning, design, execution, customer engagement and business results by making Power BI, the most successful BI platform on the planet, even better for the biggest enterprise customers.

Christian is also a renowned public speaker and a regular keynote feature in some of Microsoft’s largest events. Known for awesome demos to engage the audience, drive awareness and usage. Consulting experience driving BI, data warehousing and application development projects for enterprise customers dating back to 1999.

Creator of the BISM Normalizer, a diff & merge tool for Analysis Services tabular models.

RELATED CONTENT 🔗

Microsoft Fabric
Christian's Blog
Data God Page
BISM Normalizer