Forum Discussion
Excel query not adding new rows when refreshing
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.
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
David-J89 When viewed on-line you see the entire date range. Correct? But when you connect to the url via PQ you only get the first 100 rows. That's how it is with Yahoo Finance. Is that your problem?
If this all makes no sense, please clarify what exactly what you are trying to do and how.