Forum Discussion
Advocate IMissing Row When Importing from Web Page
Advocate I
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>
Microsoft EmployeeI 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.