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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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