MSPowerBI: Difference between revisions
| Line 6: | Line 6: | ||
* delete rows above headers (e.g. filter sums) by [[File:PowerBI_3.PNG|400px]] | * delete rows above headers (e.g. filter sums) by [[File:PowerBI_3.PNG|400px]] | ||
* set first row as header line by [[File:PowerBI_4.PNG|400px]] | * set first row as header line by [[File:PowerBI_4.PNG|400px]] | ||
* delete columns not needed by right click -> delete | |||
===Export Data to Excel=== | ===Export Data to Excel=== | ||
Revision as of 10:29, 23 February 2022
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
