Web Scraping In Power BI – How To Scrape Data From A Website In Power BI?
Extracting data from a website in Power BI is very easy. In this blog, we will show you how easy it is to extract data from website in Power BI using Bulls Dynasty dashboard (given below) like an example. Phase 1. Connect to Data To begin, just open Power BI as well as click on the option Transform Data and open the option ‘Power Query Editor’. Then click on New Source. It will provide us different options for connecting by default, however you can click on ‘More’ option given at bottom of this list to observe an extended listing of options. In the given example we would be scraping data directly from the website basketball-reference.com. To do that, we require to choose Web option underneath ‘Other’ option. Whenever you hover on that option, it tells “Import data from the Web page” as it sounds like what we wish to perform! Click Connect. When you’ve clicked on Connect option, you’ll get a screen below providing two alternatives, Basic and Advanced. Today, we would be utilizing ...