MSPowerBI: Difference between revisions
| Line 23: | Line 23: | ||
* delete columns not needed by right click -> delete | * delete columns not needed by right click -> delete | ||
====Adjust Query==== | |||
* [[File:PowerBI_6.PNG|50px]] | |||
====Error Handling==== | ====Error Handling==== | ||
* [https://radacad.com/exception-reporting-in-power-bi-catch-the-error-rows-in-power-query example see here] | * [https://radacad.com/exception-reporting-in-power-bi-catch-the-error-rows-in-power-query example see here] | ||
Revision as of 14:45, 24 February 2022
Information
- extension for local saves is *.pbix
Views
- Berichtsansicht
- Datenansicht
- Beziehungsansicht
Ressources
https://www.youtube.com/watch?v=AuYzsfXKkbM
Operation
Import Data from Excel
General Information
Power Query Editor always works with a preview of the data, to make the development process fast. When you load the data in Power BI, transformations will be applied on the entire dataset. Hence errors might have not been identified before the full import of data.
Steps
- 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
Adjust Query
Error Handling
Export Data to Excel
- move or right click in header
- select dots
- select export data
