Forum Discussion
Missing Row When Importing from Web Page
I'd start to inspect the issue from HTML source code. Is it convenient for you to post the source code of that HTML part?
Using Power BI Desktop
The Power BI ‘Web View’ displays the following entries (rows) for the ‘Major Milestones’ table:
Select and contract marketing vendor
Open Applications
Close Applications
Select Participants
Execute event / select winner
Close program / output
Kick off project
The Power BI ‘Table View’ displays the following entries (rows) for the ‘Major Milestones’ table:
Select and contract marketing vendor
Open Applications
Close Applications
Select Participants
Execute event / select winner
Close program / output
The Table View is missing the ‘Kick off project’ entry found in the Web View. Seems odd.
Below is a an HTML code snippet (where names have been changed, etc.) The snippet starts with the ‘Close program / output’ line item that shows up in both the Web View and Table View. Then below that is a separate <ul> (unordered list tag) that includes the ‘Kick off project’ line item. That <ul> section and the <li> (list item) tag is the one that isn’t showing up in the Table View.
<li class="todo " data-recording-id="999999999" data-creator-id="9659588" data-url="/9999999/buckets/9999999/todos/999999999" data-behavior="todo sortable selectable" data-edit-url="/9999999/buckets/9999999/todos/999999999/edit" data-assign-url="/9999999/buckets/9999999/recordings/999999999/assignments/new" data-position-url="/9999999/buckets/9999999/todos/999999999/position" id="recording_999999999"><span class="anchor recordable__anchor" id="__recording_999999999"></span>
<div class="indent">
<span class="todo__drag-handle" data-behavior="sortable_todo_handle"></span>
<div class="checkbox">
<label class="checkbox__label">
<input name="todo_complete" value="1" class="checkbox__input" data-behavior="todo_completion" data-move-completed="true" data-url="/9999999/buckets/9999999/todos/999999999/completion?replace=false" type="checkbox">
<span class="checkbox__button"></span>
</label>
<span class="checkbox__content">
<a href="https://3.basecamp.com/9999999/buckets/9999999/todos/999999999">Close program / output</a>
<span class="todo__hover-wrapper">
<span class="todo_assignee">
<img srcset="https://3.basecamp-static.com/9999999/people/BAhpA8Rkkw==--fc562c2b2004e0a5b24b7864c7a6046fa81ddcd0/avatar-64-x1 1x, https://3.basecamp-static.com/9999999/people/BAhpA8Rkkw==--fc562c2b2004e0a5b24b7864c7a6046fa81ddcd0/avatar-64-x2 2x, https://3.basecamp-static.com/9999999/people/BAhpA8Rkkw==--fc562c2b2004e0a5b24b7864c7a6046fa81ddcd0/avatar-64-x3 3x, https://3.basecamp-static.com/9999999/people/BAhpA8Rkkw==--fc562c2b2004e0a5b24b7864c7a6046fa81ddcd0/avatar-64-x4 4x" title="John Doe, Consultant at TopDog Thoughts" alt="John Doe" class="avatar" data-behavior="rich_avatar" data-rich-avatar-url="/9999999/people/9659588/rich_avatar" data-avatar-for-person-id="9659588" data-turbolinks-recyclable="true" src="To-dos%20%E2%80%93%20Wellness+Accel_files/avatar-64-x1.png" width="64" height="64">
<a title="Reassign…" data-remote="true" href="https://3.basecamp.com/9999999/buckets/9999999/todos/999999999/edit?assign=true">
<span class="todo_assignee_name">John D.</span>
</a> </span>
</span>
</span>
</div>
</div>
</li>
<!—in between here is a form with the Add to-do button)
<ul class="todos completed push_half--top">
<li class="todo completed" data-recording-id="999999999" data-creator-id="9659588" data-url="/9999999/buckets/9999999/todos/999999999" data-behavior="todo " data-edit-url="/9999999/buckets/9999999/todos/999999999/edit" data-assign-url="/9999999/buckets/9999999/recordings/999999999/assignments/new" data-position-url="/9999999/buckets/9999999/todos/999999999/position" id="recording_999999999"><span class="anchor recordable__anchor" id="__recording_999999999"></span>
<div class="indent">
<div class="checkbox">
<label class="checkbox__label">
<input name="todo_complete" value="1" class="checkbox__input" data-behavior="todo_completion" data-move-completed="true" data-url="/9999999/buckets/9999999/todos/999999999/completion?replace=false" checked="checked" type="checkbox">
<span class="checkbox__button"></span>
</label>
<span class="checkbox__content">
<a href="https://3.basecamp.com/9999999/buckets/9999999/todos/999999999">Kick off project</a>
<span class="todo__hover-wrapper">
<a class="todo-description-icon" title="Started / On track" href="https://3.basecamp.com/9999999/buckets/9999999/todos/999999999"></a>
<span class="todo_dates">
<span class="date date--february">
<div class="date__header">Feb</div>
<div class="date__day">1</div>
</span>
</span>
<span data-behavior="assignee_name">
<span class="todo_assignee">
<img srcset="https://3.basecamp-static.com/9999999/people/BAhpA8Rkkw==--fc562c2b2004e0a5b24b7864c7a6046fa81ddcd0/avatar-64-x1 1x, https://3.basecamp-static.com/9999999/people/BAhpA8Rkkw==--fc562c2b2004e0a5b24b7864c7a6046fa81ddcd0/avatar-64-x2 2x, https://3.basecamp-static.com/9999999/people/BAhpA8Rkkw==--fc562c2b2004e0a5b24b7864c7a6046fa81ddcd0/avatar-64-x3 3x, https://3.basecamp-static.com/9999999/people/BAhpA8Rkkw==--fc562c2b2004e0a5b24b7864c7a6046fa81ddcd0/avatar-64-x4 4x" title=" John Doe, Consultant at TopDog Thoughts" alt=" John Doe " class="avatar" data-behavior="rich_avatar" data-rich-avatar-url="/9999999/people/9659588/rich_avatar" data-avatar-for-person-id="9659588" data-turbolinks-recyclable="true" src="To-dos%20%E2%80%93%20Wellness+Accel_files/avatar-64-x1.png" width="64" height="64">
<span class="todo_assignee_name">John D.</span>
</span>
</span>
</span>
</span>
</div>
</div>
</li>
</ul>
I tried with the HTML snippet, however it is parsed in a mess in Power BI instead of reproducing the the behavior in your original post. Also I've found there're some obvious error in the snippet, like an unclosed comment.
<!—in between here is a form with the Add to-do button)
I think to find the root cause, the pbix file and the whole HTML source is required. You can upload them to a web storage and share me a link in a private message.