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
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


![Box (and Whisker) Plot Visual with Native Visuals + Error Bars
Learn how to leverage error bars and native visualizations to create a box and whisker style visualization using a bit of [DAX] magic. Tune in to learn more!
RELATED CONTENT π
Create a Range Bar with Native Visuals https://youtu.be/vowoC_akDcA
Box Chart https://en.wikipedia.org/wiki/Box_plot
Daniels GitHub https://github.com/dm-p/pbi-core-visuals-macgyver
Daniels Website https://coacervo.co/
Deneb https://deneb-viz.github.io/
BECOME A CHANNEL MEMBER π
https://www.youtube.com/channel/UCjlfQwqb-0S40XQ8seYPLSw/join
CHECK OUT OUR MERCH STORE π
https://havens-consulting.creator-spring.com/
LETS CONNECT! π§π½βπ€βπ§π½ π
https://twitter.com/HavensBI
https://www.linkedin.com/in/reidhavens
https://www.youtube.com/c/HavensConsulting
https://www.facebook.com/havensconsulting
VIDEO CHAPTERS π₯
0:00 - Start of Video
0:30 - Content Intro
HAVENS CONSULTING PAGES π
Home Page - http://www.havensconsulting.net/?utm_source=youtube-hc&utm_medium=video&utm_campaign=67ZE4qCSSw4
Blog http://www.havensconsulting.net/blog-and-media?utm_source=youtube-hc&utm_medium=video&utm_campaign=67ZE4qCSSw4
Blog Files http://www.havensconsulting.net/blog-files?utm_source=youtube-hc&utm_medium=video&utm_campaign=67ZE4qCSSw4
Files & Templates http://www.havensconsulting.net/files-and-templates?utm_source=youtube-hc&utm_medium=video&utm_campaign=67ZE4qCSSw4
Consulting Services http://www.havensconsulting.net/consulting-services?utm_source=youtube-hc&utm_medium=video&utm_campaign=67ZE4qCSSw4
Online Courses https://www.havensconsulting.net/online-courses?utm_source=youtube-hc&utm_medium=video&utm_campaign=67ZE4qCSSw4
Contact & Support - http://www.havensconsulting.net/contact-and-support?utm_source=youtube-hc&utm_medium=video&utm_campaign=67ZE4qCSSw4
EMAIL US AT π§
info@havensconsulting.net
#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #excel #powerapps #datavisualization #dashboard #bi #analytics #powerquery #dax #microsoftfabric #semanticmodel #boxplot #deneb Box (and Whisker) Plot Visual with Native Visuals + Error Bars](https://i.ytimg.com/vi/67ZE4qCSSw4/mqdefault.jpg)


![[DAX] Lib - From Zero to Community Hero (with Jake Duddy)
User-defined functions landed in DAX last September, and SQLBI launched DAXLib alongside them as a community repo for sharing libraries. There are already 30+ packages people can pull straight into their models. If youve built a UDF that made your own life easier, odds are someone else is working around the same problem.
This stream is about closing that gap. Jake Duddy joins me to walk through what it actually takes to turn a working UDF into a published DAXLib package that other people can install and use. Jake recently contributed EvaluationContext.Colour (a HEX manipulation library for SVG and conditional formatting work), so hes been through the workflow recently and has the bruises to show for it.
What well cover:
- DAXLib: what it is and why SQLBI built it
- Model-independent vs model-dependent functions, and which belong in a library
- Packaging a UDF for publication
- Submitting through GitHub
- What separates a useful contribution from noise
- Q&A throughout
GUEST BIO (Jake Duddy) π€
Jake Duddy is a Microsoft Data Platform MVP and Power BI SME based in Birmingham, UK. He runs the Evaluation Context blog covering Power BI, Fabric, DAX, and SSAS, and speaks regularly at SQLBits, the Power BI & Fabric Summit, and the Microsoft Data Platform Group Birmingham.
Links to DAXLib, Jakes blog, and his EvaluationContext.Colour library are in the comments.
#PowerBI #DAX #MicrosoftFabric #DAXLib #UDF
RELATED CONTENT π
DAX Lib https://daxlib.org/
Jakes LinkedIn https://www.linkedin.com/in/jakeduddy/
LETS CONNECT! π§π½βπ€βπ§π½ π
https://www.linkedin.com/in/reidhavens
https://www.youtube.com/c/HavensConsulting
HAVENS CONSULTING PAGES π
Home Page http://www.havensconsulting.net/?utm_source=youtube-hc&utm_medium=video&utm_campaign=6W25fR70lAk
Blog http://www.havensconsulting.net/blog-and-media?utm_source=youtube-hc&utm_medium=video&utm_campaign=6W25fR70lAk
Blog Files http://www.havensconsulting.net/blog-files?utm_source=youtube-hc&utm_medium=video&utm_campaign=6W25fR70lAk
Files & Templates http://www.havensconsulting.net/files-and-templates?utm_source=youtube-hc&utm_medium=video&utm_campaign=6W25fR70lAk
Consulting Services http://www.havensconsulting.net/consulting-services?utm_source=youtube-hc&utm_medium=video&utm_campaign=6W25fR70lAk
Online Course https://www.havensconsulting.net/online-courses?utm_source=youtube-hc&utm_medium=video&utm_campaign=6W25fR70lAk
Contact & Support http://www.havensconsulting.net/contact-and-support?utm_source=youtube-hc&utm_medium=video&utm_campaign=6W25fR70lAk
EMAIL US AT π§
info@havensconsulting.net
#PowerBI #Microsoft #DAX #SQLBI #UDF [DAX] Lib - From Zero to Community Hero (with Jake Duddy)](https://i.ytimg.com/vi/6W25fR70lAk/mqdefault.jpg)




