cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kschaefers
Resolver I
Resolver I

Problem with KickTipp Web Data Query

Hi there,

 

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

Capture.PNGas 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?

 

Capture2.PNG

 

 

 

Cheers,

Konrad

1 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.


@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop!
Microsoft Hates Greg's Quick Measures
Check out my latest book!

View solution in original post

3 REPLIES 3
Greg_Deckler
Super User
Super User

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


@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop!
Microsoft Hates Greg's Quick Measures
Check out my latest book!

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/

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.


@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop!
Microsoft Hates Greg's Quick Measures
Check out my latest book!

View solution in original post

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!