Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
tmhalila
Resolver II
Resolver II

Import data with Link from Web

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.

 

tmhalila_0-1670288827719.png

Thanks,

TM

1 ACCEPTED SOLUTION
Bifinity_75
Solution Sage
Solution Sage

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:

Bifinity_75_0-1670322531374.png


The result:

Bifinity_75_1-1670322563506.png


Best regards

View solution in original post

2 REPLIES 2
Bifinity_75
Solution Sage
Solution Sage

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:

Bifinity_75_0-1670322531374.png


The result:

Bifinity_75_1-1670322563506.png


Best regards

This is much appreciated; You saved a lot. I was struggling to find out the Python solution. 

SoExcited~GIF.gif

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.