How to get Google news Url in news dashboard

[VaibhavS31]

I am fatching the news from google news according to my some keywords, in which i am getting table which contain news headlines, news date and time, news source and news datails. Now, I want a column on source like this Url www.abc.com  which is where from news is getting picked up - is it possible to add ?


Thanks and Regards

[v-jingzhang]

Hi @VaibhavS31 

I think it is possible if you can find this URL element on the web page you used as the data source.

Is the web page available publicly? If so, can you show the URL of the google news and where the URL is on the page? Have you tried using Get Data from Web by Example feature to get the news table?

Or maybe you can refer to Chris Webb's blogs about extracting URLs from a web page. 

Chris Webb's BI Blog: Using Text.BetweenDelimiters() To Extract URLs From A Web Page In Power BI/Pow...

Chris Webb's BI Blog: Using Html.Table() To Extract URLs From A Web Page In Power BI/Power Query M

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[VaibhavS31]

Dear @v-jingzhang ,
Many thanks for the solution. I have followed the procedure which is given in this https://forum.enterprisedna.co/t/to-create-news-based-power-bi-dashbaord/11193/12 link to get the google news as per my required keywords like aluminium, copper, etc. Now I am getting the news as per my required keywords but I am not able to extract the url of that news to know exactly from which website the news is coming, can you please help me with the updated query for getting the URL of that extracted news by keeping the queries same as it is shown in the below linkhttps://forum.enterprisedna.co/t/to-create-news-based-power-bi-dashbaord/11193/12