Monday, November 19, 2018

How To Scrape Data From A Website Into Power BI (AbokiFX as an example)

Power BI is an amazing tool. I have used it to create amazing auto-updating dashboards for different reporting needs. You can view a couple that I made publicly available: https://www.nigerianelite.com/Shares/Analysis, https://community.powerbi.com/t5/Data-Stories-Gallery/Sales-Dashboard-for-a-Pizza-Restaurant/m-p/509025#M2208 and https://community.powerbi.com/t5/Data-Stories-Gallery/Nigerian-Stocks-Market-Analysis-Live-Report/m-p/175769#M850

Today, however, I will be showing you how to use Power BI to scrape data from a website and create a report/dashboard from the scrapped data. I will illustrate with AbokiFX.com data on parallel market FX rates for Nigeria. Effectively, you will be creating a report like the one below:




STEP 1
From an empty Power BI desktop file, do Get Data and pick from Web (under Other).


Follow through with providing the URL of the website to pick data from and selecting the table of data to pull into Power BI.



STEP 2
Do a couple of transformation on the data (except you are very lucky that the pulled data is already in a form that suits your report).



STEP 3
Create the report you want and publish.



You may also want to configure a scheduled refresh to make Power BI keep pulling new data from the website everyday.

Posted by at
Labels: , ,

4 comments:

  1. ramAugust 26, 2020 at 8:01 PM

    Nice and helpful article!! Thanks for sharing such an informative post.

    best training institutes

    ReplyDelete
  2. UnknownFebruary 17, 2021 at 9:32 AM

    I am genuinely thankful to the holder of this web page who has shared this wonderful paragraph at at this place
    business analytics training Guwahati

    ReplyDelete
  3. travisJuly 19, 2024 at 4:46 AM

    Great lesson, to scrape data from sources using Power BI. I recently have gotten data from AbokiFX for my research as you have advised me. With this technique, facts to support dissertation topics in political science can also be eased. I respect your posting.

    ReplyDelete
  4. archiethomasarDecember 3, 2024 at 5:00 AM

    Extracting structured or semi-structured data from a webpage and preparing it for analysis is known as "scraping" data into Power BI. The Web connection is one of the built-in features in Power BI that allows you to import data from websites without the need for any scripting. This is a detailed guide:In the Web connection, paste the URL. The "Stock Prices" table should be selected. Use Power Query to clean and arrange the data.
    Keeping a bawdy house virginia

    ReplyDelete

Subscribe to: Post Comments (Atom)