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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
tmhalila
Resolver I
Resolver I

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
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.