How to Import And Display Data From Web Page Using Power BI Desktop

So far in this series, I wrote:

1. Getting Started with Power BI Desktop
2. Create SQL Reports with Power BI
3. Create Power BI Report with Microsoft Access Database
4. How to publish BI Reports

In this article we will learn how to import and display data from web page using Power BI Desktop.

Getting Started

Start Power BI Desktop and click on the Get Data from the list in the left side bar as you can see in Figure 1.

                                     Figure 1

Now select Web data source from all data sources templates and click Connect button.

                                                                     Figure 2

Before proceeding further let’s know what is my web page and my data to display in report.

https://en.wikipedia.org/wiki/Cricket_World_Cup


                                                                              Figure 3

Once you connect with data source, You need to provide web page URL and click on OK button.

                                                                                             Figure 4

You can see all tables in left side pane.

                                                                                                      Figure 5

You can preview the table data by clicking on table.


                                                                                                      Figure 6

Click on edit if you need to rename or delete any column or detail.

                                                            Figure 7

This is my final data preview with updated column names.

                                                                                    Figure 8

In the Query Settings pane, in the Name text box, enter Cricket Records.

                           Figure 9

Now that we have completed the data into the shape that we need for our analysis, we can load the resulting table into our Report and create a few visualizations.

Now let’s load the query to the report, you have to select Close &  Apply from Home ribbon.

                                                                  Figure 10

Now let’s display data in visualization.

                                                Figure 11

I am going to show Player Name and Total in Pie Chart visualization.

                                                Figure 12

Select visualization and drag and drop selected columns.

                                                                                                            Figure 13

You can see you all the data in Pie Chart. Once hover on selected pie you can see rest of the details in pop up.

                                                                                       Figure 14

Summary

In this article you have learned how to import data from web page and display in visualizations using Power BI Desktop.

If you have any questions, then post a message in c-sharpcorner comments section.