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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
RonLieuw
Helper I
Helper I

Get data from web with table in table layout

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.

import0.png

 

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.

 

import1.png

The Tables shows the Player name and position

import2.png

How do you transform this kind of setup in PBI?

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

 

import3.png

Can the import of the results be automated in PBI?

1 ACCEPTED SOLUTION

Thank you Yuliana Gu

View solution in original post

2 REPLIES 2
v-yulgu-msft
Microsoft Employee
Microsoft Employee

Hi @RonLieuw,

 

Please follow the steps shown in below screenshots.

1.PNG

 

3.PNG

 

4.PNG5.PNG

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thank you Yuliana Gu

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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