Web url from google doc not showing all rows

[Laila92]

I am trying to load this link into PowerQuery:
https://docs.google.com/spreadsheets/d/e/2PACX-1vTNjjr7biyx2SEwyFyGqmDEVxojBxGoxRwE3Z1cp4CWqaessC5W7...

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?

[VijayP]

@Laila92 

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