In Power BI Desktop, the Web Data Source enables you to import data from web pages for analysis purposes. It exclusively imports data presented in HTML table format from websites.
It’s a very cool feature if you want to quickly get some interesting data you find any web page while surfing and want to do some analysis.
So let’s start with an example:
Follow these steps to retrieve web page data into Power BI:
Step-1: Open Power BI file
Step-2: Go to Home ribbon, click on Get Data then select Web.
Power Bi Get Data from Web Page
Step-3: In the From Web dialog box, paste the URL and click on OK.
https://en.wikipedia.org/wiki/History_of_Microsoft_SQL_Server
Web Page URL for Get Data
Step-4: Select tables which data you want to load, then click on Load.
Load Data from Web Page
Step-5: Data loading started.
Selected Data Loading
Step-6: Now you can use loaded tables for analysis.
Step-7: Through the Power Query Editor, you can apply transformations to cleanse and refine the data.
- Go to Home ribbon, then click on Transform Data(Old name Edit Queries).
- Select table from left side which you want to clean up
- Double click on table header column name & write proper column name
Power BI Edit Queries
- Remove column: Right click on column name and click on Remove
- Change Data Type: Select column and go to Transform ribbon, there is option for DataType
- After that go to Home ribbon & click on Close & Apply
- After transformation you gets updated data.
There are many option for Clean up and transformation of data, you can use one by one for more practice.
Hope you enjoyed the post. Your valuable feedback, question, or comments about this post are always welcome or you can leave us message on our contact form , we will revert to you asap.
Recommended Post: