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:
You can view the interactive version at https://community.powerbi.com/t5/Data-Stories-Gallery/Nigeria-Parallel-black-Market-FX-Rates-from-Abokifx-com/m-p/568355#M2372 and you can download the editable source file at https://drive.google.com/file/d/1emrcWqpSnBaiYntrvV9ecnUYEcVJ9I3i/view?usp=sharing
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.
Nice and helpful article!! Thanks for sharing such an informative post.
ReplyDeletebest training institutes
I am genuinely thankful to the holder of this web page who has shared this wonderful paragraph at at this place
ReplyDeletebusiness analytics training Guwahati
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