Speaker 1: Welcome back. In this video we'll see how to get a live data from a website into Power BI and then we can create charts reports from this particular live data. Let us see that. So I have opened one website named as moneycontrol.com very famous website in India. So here it displays the mutual funds, share market some different different prices it gives the live data. Let me show you the data here. Okay we have small small tables created everywhere. Okay so let me pick up any one table from here. Let's say these are top losers. We have Yes Bank, Indus Bank, UPL, Reliance and so on. So I want to create a chart for this particular data into my Power BI and whenever the data on this website changes it should automatically change into Power BI reports. Let us see practically. So remember any few names Yes Bank, Indus Bank and so on. So I'll just copy the URL from here and then I can come to Power BI, get data, click on this web option, get data web and I can paste the URL here and I'll paste the URL. Just click on OK. Now depending upon your internet speed and the connection your system configuration the time would be varying. Okay so it will take some few seconds to load the tables from that website into this box here. Okay from here you can filter the tables, filter the data you want and you can create visuals. Let us see that. So I'll wait for few seconds till it is loaded back. Yes. So now you can see there are different tables which are loaded into my Power BI. Now I can just keep on selecting the tables and pick up whichever I want. So I think I don't want this table. I will pick up this one. No. So yeah. So that's the table here Indus Bank, Yes Bank, Reliance and SBI. So suppose if I want this table, maybe it is not the same one but you can search for that table. Now if you see the column headings are very good. Company, price, change and value. I can select that table and I can just click on load button here. So load button and I can create a chart for this particular data into Power BI. Okay. Let's see Power BI here. So let's prepare a simple stacked column chart or stacked bar chart maybe. So here I can just click on. You see one more table would be loaded very soon. Yeah. So it is taking some time. Now the beauty of this one is it's a live data. Okay. Whenever the data on the website will change here, it will automatically change. Yes. So you can see that's a table too, which is loaded here. Now I can click outside, select the stacked bar chart from this table too. I'll pick up some values and some category. Let's say the company is given and the price is given here. Okay. Now I can just resize it properly so you can see. Yes. And I'll just bring it on the top. Yeah. And also I'll just go back quickly and just change the size from this drop down. Customize current team. From here I can modify the text size. Gentle and I'll make it as 20 and click on apply and save. So you can see the top losers or the top gaining from this place is for the Reliance one, which is the highest one. Okay. If I want to have a label, click on this place, select the chart from here, select the label and I can select the option from here as detail labels or data labels. So you can see what is the price here? 1529. The field which I'm using here is that is the price. So what are the different companies? So Reliance is having the highest price. Okay. That's the highest price. Second highest price is for the Indus Bank and the lowest one is for the US Bank. Okay. Now the same story again, anything changes on the website here, the data will be automatically refreshed. So if you are on the desktop, you have to manually refresh by clicking on this refresh button. But if you are connected to a Power BI service account, online account, the data will be automatically refreshed, which you'll be seeing in the last section of this particular series here. But however, I hope you have understood how to get a live data from the website. That's all for this video.