Newbie here, how can I import a file and exclude the first 20 rows?
I'm aware that I can go into edit mode and delete these rows, but I want to set BI up so that each week when I receive the same file (updated with previous weeks data) I can run a query over the data without having to delete the rows each time
I think editing the query should work. When you tell the query to delete rows or columns, you are building that into the query; each time it goes and refreshes the data, it'll run that logic as part of fetching new data.
I think editing the query should work. When you tell the query to delete rows or columns, you are building that into the query; each time it goes and refreshes the data, it'll run that logic as part of fetching new data.
Dan
Helpful resources
Announcements
New forum boards available in Real-Time Intelligence.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
