I am currently importing about 560k lines of data from 12 system reports into Power BI and then appending into a central table to start building from it, however the append is taking nearly an hour to refresh.
The number of columns in each table does vary but they all share the same 5 columns headers.
Is there a better way for me to organise the data as appending is really not suitable