Overview
Power BI is a business intelligence tool that supports so many data sources to prepare a report. As we all know, Wikipedia is a very good resource of useful information, and we can consume Wikipedia data as a data source and prepare a Power BI report.
Example
In this example, we will prepare a report on the largest-selling pharma products. We will use the following URL as a Data Source
https://en.wikipedia.org/wiki/List_of_largest_selling_pharmaceutical_products
If we open the above link, it will show the analytical data for selling a pharma product.
Note. Make sure of one thing - If we want to use Wikipedia as a data source, its information must be stored in a tabular manner. Only then can we consume its data in Power BI.
Now, let’s get started!
Step 1. Open Power BI Desktop
Open Power BI Desktop and click on Get Data.
Step 2. Select data source
Select Other Services > Web as a data source. Then, click "Connect".
Step 3. Enter URL
It will ask you to enter the URL. Post the URL as follows
https://en.wikipedia.org/wiki/List_of_largest_selling_pharmaceutical_products
Step 4. Select Tables
It will show all available tables from Wikipedia. We will select both tables. Now, click "Load".
Step 5.Loaded Tables
The below screen shows two tables loaded in Power BI.
Step 6. Rename Tables
Now, we will rename our tables. Double-click the name of an old table and rename it. We will rename our tables as “Top 10 Company” and “Pharma Company” respectively.
Join the conversation! Your thoughts help the community grow.