Beschreibung
By Sam Lowrie
Download files here:
API blog: https://www.wiseowl.co.uk/power-bi/blogs/power-bi-desktop/data-sources/using-api-key/
This video explains how to use Power BI's Web connector in 6 different ways. You'll learn how to connect HTML tables, create tables by example, connect to APIs, download files by direct link and how to loop over webpage results.
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can join this channel by clicking the following link:
https://www.youtube.com/channel/UCbi5G5PjWBaQUFy7XU_O7yw/join
Or you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!
Chapters
00:00 The Question
00:45 Connect to HTML tables
03:04 Use the Add Table Using Examples option
08:42 Treat Excel as a cloud data source
11:38 Using APIs instead of websites
14:36 Connecting directly to website files
17:11 Looping over multiple pages using parameters
23:36 Outro
Visit https://www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Power BI, DAX, VBA, Python, Visual C#, Microsoft SQL Server, SQL Server Reporting Services SSRS, SQL Server Integration Services SSIS, Microsoft Access and more!