MSPowerBI

Information

• extension for local saves is *.pbix

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
• delete columns not needed by right click -> delete

Export Data to Excel

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