Forum Discussion
EXCEL IMPORT REFRESH TOP ROWS
I'm currently carrying over data from Catapult (a chip that draws data from athletes) and each time we download it into the folder that excel is importing from, it still included those top 9 rows when refreshing, instead of just merging the new practice session data onto the entire file.
I don't want those 9 rows ever, they mess with the pivot table, and it is annoying to repeat deleting those rows manually.
How can I create a query in the beginning of this whole process that will automatically delete those rows when refreshing and loading the new csv?
4 Replies
That is standard Power Query functionality. Ingest the CSV, then "Remove top rows - top 9" then promote headers.
Power BI has no memory, and no concept of "appending to last week's import". You need to do that appending in the upstream system. For example by keeping all source files in the same folder and then combining them in Power Query.
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
