Missing Row When Importing from Web Page

[rcsjaxfl]

Hello all,

Just wondering if anyone else has run into a similar situation extracting data from a table in a web page.  I am trying to pull in data from a table on a web page in Basecamp.  Power BI shows all 7 table rows in the ‘Web View’ – see below.  But only imports 6 rows from the table – see the related Power BI ‘Table View’ below.  The only difference I see is the milestone missing in the ‘Table View’ is marked as complete in the ‘Web View’.  I apologize for the messiness but needed to cover names, etc.

I’ve included the 2 snippets below.  Any helpful suggestions will be appreciated.

 

Thank you

[Eric_Zhang]

@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]

@Eric_Zhang

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/..." 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/..." 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>

[Eric_Zhang]

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

<!—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. 

[Seth_C_Bauer]

@rcsjaxfl  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.

[rcsjaxfl]

Good morning.  I believe I have the latest desktop version...

Version: 2.44.4675.521 64-bit (March 2017)