Get data from web with table in table layout

[RonLieuw]

Hi there, I am trying to scrape data from this website: Goalscorer 2018.

Below a screen shot of the page I am trying to scrape. It shows stats for players from the soccer World Cup tournament.

#1, #2, #3 etc consist of two rows the player name as url, the players position and the player picture.

Below in the screenshot in the  column Player(s) it shows List where I want the player's name (as a minmum).

The column Clubs is empty, because I suspect in the web page this is an image.

The Tables shows the Player name and position

How do you transform this kind of setup in PBI?

The screenshot below shows the result I want without the manual copy/paste operation.

Can the import of the results be automated in PBI?

[v-yulgu-msft]

Hi @RonLieuw,

Please follow the steps shown in below screenshots.

Best regards,

Yuliana Gu

[RonLieuw · Accepted solution]

Thank you Yuliana Gu