 Hello everyone and welcome back to another video looking at Power BI. So in today's video we're going to look at how we can connect to and get data from a web page. So for us I've got a simple example here what I'm going to now bring on the screen and you can see it's just a population table what's available through Wikipedia so you could use this same URL yourself so that you can try at home to make sure you're comfortable how it's working but obviously alternatively any other website you want to use then you can obviously utilize this same method as well. One thing just to make clear is in this example we're going to be connecting to an HTML table what's obviously available on this web page you can see here so obviously depending on what data you're trying to pull in you might it might be more complex or the same as what we're looking at today so that's just one thing to bear in mind as well. So all we need to do is just copy this URL path so I'm going to do control a and copy that move that to the side and then I'm simply going to go into get data and go into web so you can see I've already clicked it already but if I hover over web we can see the option is to import data from a web page so if we click that then we'll get an option what pops up here so simply all this is asking us for is our URL path I'm going to enter there though you do have advanced options available to you but we're going to keep this very basic and just stick with all the basic options for the purpose of this video by clicking okay what Power BI is going to do is it's obviously going to look at that connection and try and obviously and establish a connection to make sure it's obviously all working and then this navigator once it's loaded will display to us all of the available data sources that it has found on that web page so primarily it's going to be focusing at looking at tables so HTML tables available to us if we want to navigate through and just see what we're looking at we can obviously select one of these tables identify if it's the information that we need and obviously if not we can then move on to the more tables but I know for however that we want to go look at HTML tables and we can see the first one it's clearly defined as a HTML table is this desired table we have here so we can see we've got our rank country population which does match entirely with what we had here in our browser so we can move that to so once again and all I'm going to do now is simply click on load and what that will do is Power BI will now import that data into our dashboard the benefit of obviously connecting to the data in this manner is if that was a table that's going to get updated regularly maybe it's daily weekly or whatever it is it always ensures that once that table is updated and we refresh our data the new data is going to be populated into our dashboard so it just saves us that has to obviously saving something to excel connect into that excel which is obviously only going to be updated once we ourselves go to update that data so to put that in short our data is now lively connect or has a live connection with its source and we can now just play around this as we desire so if you wanted to create or recreate that basic table we can simply put a table into our display and we can then bring all that fields in so go rank country population and you'll see that they've been populated in here for us as well so if we just make that bigger and for some reason rank although it is if we not put it into rank order so if we go into rank like so also got the highest the lowest all right so our data needs a bit of playing around with but we can see what we have available to us and obviously using population here we can then go through and identify the population for each country and alternatively what we could do here as well let's say we wanted to move that to the side over here and let's just bring a visual and our visual a slicer so maybe we want to put country into our slicer field over here and let's say again we've got only a few areas of interest maybe we only want to look at let's go into the United States maybe the United it's enable so what we need to do here I want to select multiple countries well let's step back a minute we can see by selecting the United Kingdom we've now got the United Kingdom what its rank is and what the total population is for the United Kingdom as well or if I go to United States we can get that as well because I want to get about select multiple values if we didn't know this already all we need to simply do with our slicer once selected is go down into selection controls we're using the paint roller icon here and we can do multiple select is on and let's go let's turn that off so we should now have to do multiple selection yet we have indeed so let's go back down to where was it let's go United Kingdom United States and what's the other randomly selected options we can do let's go for I can't even think when wine's gone blank now let's say we're going to go for India Indonesia Hong Kong and maybe Greece just to click the first few that I saw and we can now bring into this a graph so let's go for a simple bar chart just click in and it's obviously disappeared somewhere let's try that again yep there it is the bar chart and now we can bring country into our axis population into our values and we've now simply created a nice well not maybe a nice we might again want to do a bit more work to it but we've created a simple chart from that data on the web so point being we've connected to data on the web and we're now able to build a dashboard or combine that data with other information and detail we have within our dashboard so if you found the video useful please don't forget to give the video a like it not only shows me more content that you'd be interested in seeing but also does help that all important YouTube algorithm to ensure more people searching for such questions like this are able to find this video and if it's the first time you've come across the channel or you've watched our videos in the past please do ensure that you are subscribed to the channel and make sure you hit that bell notification button that way you'll be notified of all of our future videos as and when they come out so thank you very much for watching and we'll see you in the next video