Missing Row When Importing from Web Page

Question

Hello all,&nbsp;Just wondering if anyone else has run into a similar situation extracting data from a table in a web page.&nbsp; I am trying to pull in data from a table on a web page in Basecamp.&nbsp; Power BI shows all 7 table rows in the ‘Web View’ – see below.&nbsp; But only imports 6 rows from the table – see the related Power BI ‘Table View’ below.&nbsp; The only difference I see is the milestone missing in the ‘Table View’ is marked as complete in the ‘Web View’. &nbsp;I apologize for the messiness but needed to cover names, etc.&nbsp;I’ve included the 2 snippets below. &nbsp;Any helpful suggestions will be appreciated.&nbsp;&nbsp;&nbsp;&nbsp;Thank you

anonymous · Answer

rcsjaxfl&nbsp; All the found tables highlighted yellow for me, so the fact that in your web view it isn't explicitly outlined as a table could be an issue. Do you have the latest Desktop version as well, probably won't effect things, but just curious. I've never experienced what you outline.

eric_zhang · Answer

rcsjaxfl
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?

rcsjaxfl · Answer

Good morning. &nbsp;I believe I have the latest desktop version...&nbsp;Version: 2.44.4675.521 64-bit (March 2017)&nbsp;&nbsp;&nbsp;

rcsjaxfl · Answer

Eric_Zhang&nbsp;Using Power BI Desktop&nbsp;The Power BI ‘Web View’ displays the following entries (rows) for the ‘Major Milestones’ table:&nbsp; &nbsp;Select and contract marketing vendor &nbsp;&nbsp;&nbsp; &nbsp;Open Applications&nbsp; &nbsp;Close Applications&nbsp; &nbsp;Select Participants&nbsp; &nbsp;Execute event / select winner&nbsp; &nbsp;Close program / output&nbsp; &nbsp;Kick off project&nbsp;The Power BI ‘Table View’ displays the following entries (rows) for the ‘Major Milestones’ table:&nbsp; &nbsp;Select and contract marketing vendor&nbsp; &nbsp;Open Applications&nbsp; &nbsp;Close Applications&nbsp; &nbsp;Select Participants&nbsp; &nbsp;Execute event / select winner&nbsp; &nbsp;Close program / output&nbsp;The Table View is missing the ‘Kick off project’ entry found in the Web View.&nbsp; Seems odd.&nbsp;Below is a an HTML code snippet (where names have been changed, etc.)&nbsp; 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 &lt;ul&gt;&nbsp; (unordered list tag) that includes the ‘Kick off project’ line item.&nbsp; That &lt;ul&gt; section and the &lt;li&gt; (list item) tag is the one that isn’t showing up in the Table View.&nbsp;&nbsp;&lt;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"&gt;&lt;span class="anchor recordable__anchor" id="__recording_999999999"&gt;&lt;/span&gt;&nbsp;&nbsp;&nbsp; &lt;div class="indent"&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;span class="todo__drag-handle" data-behavior="sortable_todo_handle"&gt;&lt;/span&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;div class="checkbox"&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;label class="checkbox__label"&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;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"&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;span class="checkbox__button"&gt;&lt;/span&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/label&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;span class="checkbox__content"&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;a href="https://3.basecamp.com/9999999/buckets/9999999/todos/999999999"&gt;Close program / output&lt;/a&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;span class="todo__hover-wrapper"&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;span class="todo_assignee"&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;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"&gt;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&lt;a title="Reassign…" data-remote="true" href="https://3.basecamp.com/9999999/buckets/9999999/todos/999999999/edit?assign=true"&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;span class="todo_assignee_name"&gt;John D.&lt;/span&gt;&lt;/a&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/span&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/span&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/span&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/div&gt;&nbsp;&nbsp;&nbsp; &lt;/div&gt;&lt;/li&gt;&nbsp;&nbsp;&lt;!—in between here is a form with the Add to-do button)&nbsp;&nbsp;&nbsp;&nbsp; &lt;ul class="todos completed push_half--top"&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;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"&gt;&lt;span class="anchor recordable__anchor" id="__recording_999999999"&gt;&lt;/span&gt;&nbsp;&nbsp;&nbsp; &lt;div class="indent"&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;div class="checkbox"&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;label class="checkbox__label"&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;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"&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;span class="checkbox__button"&gt;&lt;/span&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/label&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;span class="checkbox__content"&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;a href="https://3.basecamp.com/9999999/buckets/9999999/todos/999999999"&gt;Kick off project&lt;/a&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;span class="todo__hover-wrapper"&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;a class="todo-description-icon" title="Started / On track" href="https://3.basecamp.com/9999999/buckets/9999999/todos/999999999"&gt;&lt;/a&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;span class="todo_dates"&gt;&nbsp;&nbsp;&nbsp;&nbsp; &lt;span class="date date--february"&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;div class="date__header"&gt;Feb&lt;/div&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;div class="date__day"&gt;1&lt;/div&gt;&nbsp;&nbsp;&nbsp; &lt;/span&gt;&nbsp; &lt;/span&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;span data-behavior="assignee_name"&gt;&nbsp;&nbsp;&nbsp; &lt;span class="todo_assignee"&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;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"&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;span class="todo_assignee_name"&gt;John D.&lt;/span&gt;&nbsp;&nbsp;&nbsp; &lt;/span&gt;&lt;/span&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/span&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/span&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/div&gt;&nbsp;&nbsp;&nbsp; &lt;/div&gt;&lt;/li&gt;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/ul&gt;

eric_zhang · Answer

rcsjaxfl
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.
&nbsp;
&lt;!—in between here is a form with the Add to-do button)
&nbsp;
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&nbsp;private message.&nbsp;

Forum Discussion

Missing Row When Importing from Web Page

5 Replies

Related content

missing data

missing data

Generating Missing Data

Inferring Missing Columns and Imputing Missing Data

Missing information