The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now
This is Report using Wikipedia information about the World Cup Russia 2018.
The file had mostly transformation in Power Query.
I take some ideas of transformations from Curbal
https://www.youtube.com/channel/UCJ7UhloHSA4wAqPzyi6TOkw
eyJrIjoiZWNmMDcwYzAtNGFkYS00YWEzLWFiNDMtMjg1YmFiMjlmZjI3IiwidCI6ImMxMTAzZGNkLTYwNzktNGZjYi04ZjZjLWU1NjE1ZmFhMTJhZiIsImMiOjR9
Wonderful and well done!
Where did you get the image of the players?
/Ruth
Hi, using the same technique of the flags and with the Help Of Excel
Source:
https://www.fifa.com/worldcup/players/browser/
1: Select All and Paste in Excel
2. Use this Macro to Extract the Links
https://www.extendoffice.com/es/documents/excel/3229-excel-extract-hyperlink-from-image.html
Sub ExtractHyperlinkFromPicture() 'updateby Extendoffice 20151015 Dim xSh As Shape Dim xScreen As Boolean xScreen = Application.ScreenUpdating Application.ScreenUpdating = False For Each xSh In ActiveSheet.Shapes If xSh.Type = msoPicture Then On Error Resume Next Range(xSh.TopLeftCell.Address).Offset(0, 3).Value = xSh.Hyperlink.Address On Error GoTo 0 End If Next Application.ScreenUpdating = xScreen End Sub
The result is:
Select All & Copy and Paste Special --Values in an new Sheet
Now i have the link to every player
After That Import In Power BI Desktop
And to Obtain the Image use this to Extract the Code of Every Player (ID-Jugador)
And Use a Custom Column:
Regards
Victor
Oh, so the link to the images was there?? Well done!