Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Integrate a web content in PBI

Dear experts,

 

I would like to build a dashboard consolidating macro economics data and visual (inflation rate, currency rate, raw material price) in a power BI report.

 

How can we automatically integrate a web content (a graph from a web site) in a report?

 

Many thanks in advance for your support?

 

Best regards

 

FLdgv

4 Replies

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Icon for Community Support rankCommunity Support

    Hi Anonymous ,

     

    The official documentation has clear step-by-step instructions for this.

    Extract data from a Web page by example in Power BI Desktop - Power BI | Microsoft Docs

    Filter the fields you want to integrate by. Then select "OK" to go to the Power Query editor. You can apply more conversions or adjust the data

     

    Or you can choose to dynamically embed web pages in Power BI, refer to the following blog link.

    Dynamically Embedding Web Pages in Power BI - P3 Adaptive

     


    Best Regards,
    Henry


    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable

    Dear amitchandak 


    Many thanks for your answer and documentation shared.

     

    However, to precise my request, the goal  :

    1- is not to extract data from a web site, but just to extract a picture or a graph from a web site (as I 'll not be able to download the data nuturing the web site ... even if I would like to !) 

    Example : Rotterdam Bunker Prices - Ship & Bunker (shipandbunker.com) 

     

    2- is not to embed a full website in my power Bi dashboard, but just to capture one single induvidual chart / graph from a full website

    Example : I just need the graph for the period starting 01.01.2021

     

    At the end, my goal is to build a dashboard, usind different graph from different website to gather in one slide the macro-economics indicators.

     

    Many thanks again for your support.

     

    BR

     

  • Anonymous's avatar
    Anonymous
    Not applicable

    Dear Experts,

     

    Just a message to pop-up my message, as we still did'nt find a relevant solution to integrate web content (graphs or pictures or texts) in a PBI report.

     

    As this could be helpful for many of us, anyone ready to adress this challenge?

     

    Many thanks for your support

     

    BR