Connecting APIs with Power Query - Not so Low Code? (with Erik Svensen) @HavensConsulting
Connecting APIs with Power Query - Not so Low Code? (with Erik Svensen)  @HavensConsulting
Uploaded June 2023 | Updated November 2026, 3 days ago
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.

VIDEO CHAPTERS πŸŽ₯
0:00 - Video Start
5:00 - Start of Livestream

RELATED CONTENT πŸ”—
Erik's Blog -- eriksvensen.wordpress.com
Erik's LinkedIn -- linkedin.com/in/eriksvensen
Erik's Twitter -- twitter.com/donsvensen
CatMan Solutions -- catmansolution.com
Slide Deck Link -- bit.ly/3NoRd9Z

LET'S CONNECT! πŸ§‘πŸ½β€πŸ€β€πŸ§‘πŸ½ 🌟
-- twitter.com/HavensBI
-- linkedin.com/in/reidhavens
-- youtube.com/c/HavensConsulting

CHECK OUT OUR MERCH STORE πŸ‘•
-- havens-consulting.creator-spring.com

HAVENS CONSULTING PAGES πŸ“„
Home Page -- havensconsulting.net/?utm_source=youtube-hc&utm_medium=video&utm_campaign=5SRzkZMkGLQ
Blog -- havensconsulting.net/blog-and-media?utm_source=youtube-hc&utm_medium=video&utm_campaign=5SRzkZMkGLQ
Blog Files -- havensconsulting.net/blog-files?utm_source=youtube-hc&utm_medium=video&utm_campaign=5SRzkZMkGLQ
Files & Templates -- havensconsulting.net/files-and-templates?utm_source=youtube-hc&utm_medium=video&utm_campaign=5SRzkZMkGLQ
Consulting Services -- havensconsulting.net/consulting-services?utm_source=youtube-hc&utm_medium=video&utm_campaign=5SRzkZMkGLQ
Online Course -- havensconsulting.net/online-courses?utm_source=youtube-hc&utm_medium=video&utm_campaign=5SRzkZMkGLQ
Contact & Support -- havensconsulting.net/contact-and-support?utm_source=youtube-hc&utm_medium=video&utm_campaign=5SRzkZMkGLQ

EMAIL US AT πŸ“§
info@havensconsulting.net

#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #excel #powerapps #datavisualization #dashboard #bi #analytics #powerquery #pq #api #advancededitor
Connecting APIs with Power Query - Not so Low Code? (with Erik Svensen)One-Click Time Intelligence Measures with Tabular Editor Scripts!Model Your Data in Power BI: Star Schemas, Filter Flow & Field ListsBox (and Whisker) Plot Visual with Native Visuals + Error BarsCreate your own Power Query Connector for Power BI & Dataflows (with Miguel Angel Escobar)Design Scalable BI Solutions with BI Solution Algebra (with Chris Wagner)[DAX] Lib - From Zero to Community Hero (with Jake Duddy)Empower BI Professionals to Do More Using Microsoft Fabric (with Christian Wade)Havens Consulting Live StreamAvoid AI noise: use weekly summaries, not daily panicIntroducing the Core Visuals - Vision Board (Miguel Myers & Alper Sarikaya)Next Generation Maps in Power BI with Icon Map (with James Dales)
Havens Consulting |

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

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER