Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hello family,
I am trying to import data from Wikipedia. The link is HERE. The only problem I get when transforming this data is the missing URL (Link) from the column Link; at the end of the analysis, I want to have a visual with Links for each YouTube channel and to be dynamic in case of any changes from the website.
Thanks,
TM
Solved! Go to Solution.
Hi @tmhalila , in Power Query, in Html.Table (second step), insert this code (previous the full table extraction code) :
Html.Table(Origen, {{"Link", "a[href^=""http""]", each [Attributes][href]}
Like the image:
The result:
Best regards
Hi @tmhalila , in Power Query, in Html.Table (second step), insert this code (previous the full table extraction code) :
Html.Table(Origen, {{"Link", "a[href^=""http""]", each [Attributes][href]}
Like the image:
The result:
Best regards
This is much appreciated; You saved a lot. I was struggling to find out the Python solution.
User | Count |
---|---|
141 | |
71 | |
70 | |
54 | |
53 |
User | Count |
---|---|
208 | |
95 | |
64 | |
61 | |
57 |