Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!