![]() ![]() Promote headers: Now that our data is has no extra rows on top, let’s use row number 3 as header.From “Home ribbon” in Power Query editor, using the “Remove rows” button, remove top 2 rows. Remove top rows: The file contains 2 rows of header information which is not needed.Once the data is loaded into Power Query, you can quickly apply all the necessary data cleansing steps in there. Step 2: Apply data cleansing steps in Power Query Close & Load button: This button, also shown as “Publish” in Power BI is what we use to close Power Query and return to main application (Excel or Power BI).You can enable / disable this formula bar from “View ribbon”. Formula bar (optional): The optional formula bar shows corresponding M Language code for current step. ![]() We use this to make changes to the query or delete any steps.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |