Jan 07 2022 07:24 PM
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.
Jan 07 2022 07:38 PM
@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.
Jan 07 2022 07:45 PM
Jan 07 2022 07:51 PM - edited Jan 07 2022 07:53 PM
@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?
Jan 07 2022 07:59 PM
Jan 07 2022 08:09 PM
@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.
Jan 07 2022 11:16 PM - edited Jan 07 2022 11:39 PM
My problem is that it doesn't refresh and add new rows. Let's say I created a web query on the 6th and now it's the 7th, now I need data for the 7th. When I click on refresh, it doesn't add a row for the 7th but does update for the other rows. It just doesn't add more rows or replace any rows, it only updates the rows for the 6th and back when I click on refresh. I'm a new excel user.