Problem with KickTipp Web Data Query

[kschaefers]

Hi there,

I am downloading data from https://www.kicktipp.de/zalando2016/tippuebersicht?wertung=einzelwertung&sortBy=gesamtpunkte&ranking...

as you can see in the screenshot above, the table is a fairly standard HTML table. The table is also detected in Power BI. However for some reason there are not all of the columns in the table, when I import it. Anyone have an idea? or is the web connector broken?

Cheers,

Konrad

[Greg_Deckler]

Any chance you can post the source HTML of the table?

[kschaefers]

The link I posted is public https://www.kicktipp.de/zalando2016/tippuebersicht?wertung=einzelwertung&sortBy=gesamtpunkte&ranking...

Unfortunately the table html is larger than 20k characters, so I can't post it here. But i created a fiddle

https://jsfiddle.net/2sbg5hcq/

[Greg_Deckler · Accepted solution]

OK, took a look at this. That is a weirdly formatted table. I haven't really seen a thead element with multiple tr's in it. I'm guessing that is what is causing the issue. You can log it as an issue. However, I'm not up on my HTML standards 100% so I'm not even sure that is kosher HTML.

You could potentially choose the Document level and do the old expand drill down into the DOM by hand essentially. Might get you there.