Forum Discussion

Mekist's avatar
Mekist
Icon for Helper III rankHelper III
6 months ago
Solved

Retrieving data via HTML

Hello I am retrieving company information as a table using the following query. Since the data is retrieved from the table, a timeout issue occurs on the website. Is it possible to retrieve the data...
Need Help
Show and Tell
  • Mekist's avatar
    Mekist
    6 months ago

    v-saisrao-msft  Hello

     

    Thank you for your support, there is no waiting problem

v-saisrao-msft's avatar
v-saisrao-msft
Icon for Community Support rankCommunity Support
6 months ago

Hi Mekist ,

The timeout probably happens because the table loads dynamically, so Web.BrowserContents may capture the HTML before everything is fully rendered. To make it more stable, try using the WaitFor option to delay extraction until the table is visible, and increase the command timeout for more loading time. If you can access the data as static HTML or through an API, using Web.Contents would be faster and more reliable.

Troubleshooting the Power Query Web connector - Power Query | Microsoft Learn

Power Query Web connector - Power Query | Microsoft Learn

Web.BrowserContents - PowerQuery M | Microsoft Learn

 

Thank you.