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.
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
Solved! Go to 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.
Any chance you can post the source HTML of the table?
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
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.
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.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |