Forum Discussion

informer's avatar
informer
Icon for Helper I rankHelper I
1 year ago
Solved

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 fo...
  • v-aatheeque's avatar
    1 year ago

    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!