Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
 
					
				
		
Hello,
I'm trying to parse data from 8a.nu/scorecard/ but when I use the following M code I don't obtain the complete table.
let
    Source = Web.Page(Web.Contents("https://www.8a.nu/scorecard/eduardo-ruano/routes/?AscentClass=0&AscentListTimeInterval=0&AscentListViewType=1&GID=facc790cd931277288b4cbc3576bb498")),
    Data = Source{16}[Data],
    #"Changed Type" = Table.TransformColumnTypes(Data,{{"Column1", type text}, {"Column2", type text}, {"Column3", type text}, {"Column4", type text}, {"Column5", type text}, {"Column6", type text}, {"Column7", type text}, {"Column8", type text}, {"Column9", type text}, {"Column10", type text}, {"Column11", type text}, {"Column12", type text}})
in
    #"Changed Type"Table doesn't show the 2nd column that contains
<img src="/scorecard/images/979607b133a6622a1fc3443e564d9577.gif">
I have tried to parse the web reading it as text file, but I obtain an empty file with 0 Bytes:
let
    Source = Table.FromColumns({Lines.FromBinary(Web.Contents("https://www.8a.nu/scorecard/eduardo-ruano/routes/?AscentClass=0&AscentListTimeInterval=0&AscentListViewType=1&GID=facc790cd931277288b4cbc3576bb498"), null, null, 1252)})
in
    SourceAny idea to get this column in my PowerBi table??
Thanks.
 
					
				
		
@Anonymous,
I have found no method to import this column to Power BI Desktop, I suspect that this type of column is not supported in Power BI Desktop.
Regards,
Lydia
 
					
				
				
			
		
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
