MSPowerBI: Difference between revisions
(Created page with "==Operation== ===Export Data to Excel=== * move or right click in header * select dots 400px * select export data 400px") |
|||
| Line 1: | Line 1: | ||
==Operation== | ==Operation== | ||
===Import Data from Excel=== | |||
* select import and file | |||
* select transform (not load) | |||
* 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]] | |||
===Export Data to Excel=== | ===Export Data to Excel=== | ||
Revision as of 10:28, 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
Export Data to Excel
- move or right click in header
- select dots
- select export data
