Fetch Web Data in Power BI


Introduction

Reporting on web data has been a fascinating part of developing any dashboard or reports in Power BI. Often this data is available either free that can be consumed anonymously or by using some kind of authentication mechanism. In this article, I’m going to demonstrate how to connect to a web application from Power BI using a simple authentication mechanism (API Key) and generate a basic report on it.

Solution

For this article, the web application we are going to use is Alphavantage. It is a portal where you can fetch details of stock prices listed in the NASDAQ.