cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ruanolin Frequent Visitor
Frequent Visitor

Missing column when parsing web with PowerBI

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.

1 REPLY 1
Moderator v-yuezhe-msft
Moderator

Re: Missing column when parsing web with PowerBI

@ruanolin,

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

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