Forum Discussion
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
- amitchandak
Super User
Anonymous , You can get data as web and then you can schedule incremental in power bi service
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-connect-to-web-by-example
- v-henryk-mstf
Community 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. - AnonymousNot 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
- AnonymousNot 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