How to use Power BI with Web Data Source
Hello everyone, in this blog we will see how to connect Power BI with web as a data source.We will take moneycontrol.com ‘s data source for stock market analysis and we will generate a report based on it.
Step 1: Go to get data source in Power BI desktop and select web as a data source.
Step 2: Paste the following URL in the URL section and press ok. It will load the relevant table from the URL. Now select the table 0 dataset as that dataset contains the columns that we need.
URL:
https://www.moneycontrol.com/stocks/marketinfo/eps/bse/index.html
Step 3: Now the dataset is with us lets visualize it with the effective visualizations we have in power BI
Step 4: This is an optional step as the data came from data source with little extra information with it so I used a SUBSTITUTE function to remove the unnecessary words from company name.
DAX:
Refined Company Names = SUBSTITUTE([Company], “Add to Watchlist Add to Portfolio”, ” “)
I hope this helps.