Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Web url from google doc not showing all rows

I am trying to load this link into PowerQuery:
https://docs.google.com/spreadsheets/d/e/2PACX-1vTNjjr7biyx2SEwyFyGqmDEVxojBxGoxRwE3Z1cp4CWqaessC5W7mMYV_AEim9sB5XYqIkUBYcnAoop/pubhtml?utm_campaign=20200318_COVID19&utm_content=123319115&utm_medium=social&utm_source=linkedin&hss_channel=lcp-6628696#

When loading it, i do see part of the data, but the rows I marked in yellow in the screenshot do not show up. 

I know that normally you use the following steps to load the data:

  1. Remove /edit?usp=sharing from the URL and add /export?format=xlsx&id= in its place
  2. Copy the ID between /d/ and /export… (see red box below)
  3. Paste the ID at the end of the URL (see green box below

 

But the link looks different and after playing around with it I can't get it to work properly.  And ideas on how to get the marked rows to show up?

Need Help

1 Reply

  • VijayP's avatar
    VijayP
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Anonymous 

    I have tried the link and i Found all the rows are getting loaded . Instead of Table 11 , I ahve selected Table 2

    I have used the link as it is and got the result as below picture shows, I think if you can do a slight cleanup of the data you will have complete Data.

    IF you find this a solution please mention the same and share your Kudoes.

    you can watch my Videos on Power BI and Excel at this link www.youtube.com/perepavijay