Forum Discussion
Excel and Power Query, order altered when new data gets added on refresh
Greetings, i couldnt find a dedicated Power query and Excel forum, so ill try to ask here. I have data collected from an email (some platform notifications) that i use in Power BI, but users need...
Even when letting the new data on the bottom new rows are still put above the last one, before it was filled with "0" until the last row, and now after a refresh the new 4 rows are above last row, this means the data written in excel on the 2 new columns added after the query table loads. Im looking into some way of self referencing the table so it writes the new columns to the query, seems a bit complex but will report later.