1 Nov’19

UncategorizedHow 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.

Written by

Aditya Somwanshi

Software Engineer

Leave a Reply

Your email address will not be published. Required fields are marked *

Want to streamline your business processes?

  • This field is for validation purposes and should be left unchanged.

Recent Articles

  • Performing Update operation in Microsoft Dynamics NAV through Integration in Scribe Online

    13 November’ 2019

    Introduction: Use the Update Block to update existing records in the source or target datastore. While integrating w...

    Read more
  • Adding Microsoft Dynamics NAV Connection in Tibco Scribe Online

    13 November’ 2019

    Introduction: Establishing a connection is an important step before developing a solution for Integration. While integra...

    Read more
  • Time zone Conversion from Microsoft D365 for SSRS Reporting

    6 November’ 2019

    Introduction: Converting Date/Time values according to a time zone is quite challenging task in SSRS Reporting. For D365...

    Read more
  • How to Synchronize Office 365 and Zoho People?

    4 November’ 2019

    If your organization is using Zoho People and Office 365, you will find this article very useful. In this article we are...

    Read more
  • Check Plugin Timeout issues using Tracing in D365 CE

    31 October’ 2019

    In Dynamics plugin implementations, you might have lengthy complex plugins that makes calls to Dynamics several times. I...

    Read more