Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
informer
Helper I
Helper I

Power Query - website - incomplete uploading

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.

1 ACCEPTED SOLUTION
v-aatheeque
Community Support
Community Support

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!

View solution in original post

4 REPLIES 4
v-aatheeque
Community Support
Community Support

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!"

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!

 

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
Community Support
Community Support

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!

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Top Solution Authors
Top Kudoed Authors