Forum Discussion
Excel query not adding new rows when refreshing
I have an excel query that I would like to use but it doesn't add new rows when I refresh the page and it only adds the rows that are there when I added the query. Please help me with this.
David-J89 As in Power Query? What are you connecting to and how?
For instance, when you connected to a named range and add data outside that range, PQ will not pick-up the new rows of data. Better to transform the data to a structured table and connect to the table instead as it will automatically grow when you add data at the bottom.
- The source of the data is Yahoo finance. How do I transform the data to a structured table?
David-J89 OK, you are getting data from the web. Then you are not connecting to a range or a table. Would you mind sharing the full url you are connecting to?
- This is the URL: https://finance.yahoo.com/quote/BNB-USD/history?period1=1610078337&period2=1641614337&interval=1d&filter=history&frequency=1d&includeAdjustedClose=true
