Power Query - website - incomplete uploading

[informer]

Hey,

I need to load the lines on the CoinMarketCap site.

Each page displays 100 lines

In Power Query, the result of loading a page is :

- Complete for the first 10 lines
- Incomplete for the remaining 90 rows, as only the Name and Price columns are displayed.

Any idea as to the cause of this error?

Thanks in advance.

[v-aatheeque]

Hi @informer ,

We haven’t heard back from you regarding the last response, so we wanted to check if your issue has been resolved.

If it has, please click 'Accept Answer' and 'Yes' if you found the response helpful. If you have any further queries, feel free to let us know.

Thank you!"

[v-aatheeque]

Hi  @informer 

We wanted to follow up regarding your recent inquiry to see if your issue has been resolved.

If your issue has been addressed, please click 'Accept Answer' and select 'Yes' if you found our response helpful.

If you have any further questions or need additional assistance, please don't hesitate to reach out.

Thank you for your time!

[v-aatheeque]

Hi @informer ,

If our response addressed  your query, please mark it as Accept Answer and click Yes if you found it helpful.

Should you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!

[v-aatheeque · Accepted solution]

Hi @informer ,
Thanks for reaching out to the Microsoft Fabric Community forum.

It sounds like you're encountering an issue where Power Query is only partially loading data from the CoinMarketCap site. This could be due to several reasons:

• Power Query has a default data load limit, and it might be stopping after loading the first 10 rows. You might need to manually load more data.
• After loading the data, you may need to transform it in Power Query to ensure all columns are displayed correctly.
• Check if there are any steps in your query that might be filtering out the additional columns.
• Go to the Power Query settings and increase the data load limit if it's set too low. Sometimes, you might need to manually click "Load More" in Power Query to fetch additional data
• Look for any error messages in Power Query that might indicate what is going wrong. This can provide clues on how to resolve the issue.

please consider this reply as "Accept as Solution" and click on "Yes" so that other community members will find it more quickly.

If you continue to face issues, feel free to reach out to us for further assistance!