Forum Discussion

queryfan's avatar
queryfan
New Member
9 years ago

How to load Data from a webpage having multiple pages

Hello,   I am trying to import data using the below query , But I am able to import only the first 30rows in table0..How do I loop to the next table and import the remaing?   Please suggest neces...
Need Help
Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

This is also worth reading.

queryfan's avatar
queryfan
New Member
9 years ago

Thank you

 

I have no knowledge about the parameters in the URL.

 

Could you please let me know how to identify the variable so that I could loop through all the sheets and get the data using power query.

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Icon for Community Support rankCommunity Support
    9 years ago

    Hi queryfan,

     

    You can't just use the site URL to get table data in desktop simply. You need to view corresponding API and find the actual URL to get all table data. So the first thing you need to do is contacting Money Control to find the rest API to get data. Then you can follow this simple to do it in desktop: How to call REST APIs and parse JSON with Power BI

     

    Best Regards,
    Qiuyun Yu