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.
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 Source
Any 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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.