Power BI and Web API's - not so low code ?

on YouTube ↗51m

" summary

Live demos show Power BI calling real REST APIs using Power Query code: using web.contents with a relativePath to send headers and JSON content, switching GET/POST and handling pagination. Examples include pulling ~9,424 crime records for two months, reading Dynamics/Data verse tables (top 10/30), paging 6,000+ ERP accounting rows via calculated page lists, listing 11 Spotify playlists with client ID/secret OAuth, POSTing to OpenAI completions, and using community Power BI Admin REST functions to enumerate workspaces — all built and run in Power Query.

AI-written summary · about

" chapters (9)

1. 0:00Introduction and speaker background
2. 3:36Web.contents function basics
3. 5:53Crime data from police API
4. 15:23Data Verse REST API integration
5. 19:11ERP system API with authentication
6. 28:04Spotify API and authentication
7. 35:09OpenAI API integration demo
8. 43:42Power BI admin REST API overview
9. 50:14Q&A and key takeaways

" related talks

• 06mExcel REST API (Public preview)Sudhi Ramamurthy · Connect(); // 2015
• 52mAPI-powered digital ecosystemsGeir Sjurseth · Apidays LIVE Paris 2020
• 26mData with a mission: a COVID-19 API case studyMatt McLarty · Apidays LIVE Paris 2020
• 04mSneak peek into the API world outside RESTAnkita Tripathi · Write the Docs Australia & India 2020
• 30mAPI Security - Divide & ConquerTom Zahov Zaubermann · code.talks 2022
• 46mAPI Security – Divide & ConquerTom Zahov Zaubermann · 4Developers 2021
• 01h 18mProfessional Web APIs using ASP.NET Core 2.1Alex Thissen · .NET fwdays'18
• 43mIncrease developer velocity with Azure SQL Database from data to APIAnagha Todalbagi, Silvano Coriani, Jerry Nixon, Davide Mauri, Drew Skwiers-Koballa, Muazma Zahid, Ikenna Okeke, Nannette Sperling, Alison Walters · Microsoft Build 2023