MSPowerBI

Operation

Import Data from Excel

• select import and file
• select transform (not load)
• delete rows above headers (e.g. filter sums) by
• set first row as header line by

Export Data to Excel

• move or right click in header
• select dots
• select export data