cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rcsjaxfl
Frequent Visitor

Missing Row When Importing from Web Page

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.

 

Table View.JPGweb view.jpg 

 

 

Thank you

5 REPLIES 5
Eric_Zhang
Microsoft
Microsoft

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

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

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

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


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

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

 

Version: 2.44.4675.521 64-bit (March 2017)

 

 

 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors