Power BI - Editing Data (row by row) in a Manually Created Table (6) - Hands On Demo!
There are all sorts of ways to load data into Power BI. But, sometimes you just want to create your own table (on-the-fly.) This is relatively easy, but editing that manual table (in a row-by-row fashion) is not so intuitive.
Yes, there is some functionality that allows you to perform deletes (removals) and replace values, but those incorporate find and replace type logic, when all you really want to do is edit, delete, and insert rows and columns ala-carte(selecting one row at a time), like you do in Excel.
This video will show you how to easily edit the data (row by row) in your manual tables with only a few clicks of your mouse.
( / greg-c-coopman-b07b54103 )
Note: One thing I missed to show is how to add a column, that is accessible for edit in the Create Table browser. The way to do this, is to simply click on the * in the far top right corner and that will create a new column that you can edit in the same way I explained in the video.
Also, I found out that you can change the column name in the Create Table window by simply clicking on the column name and start typing. I did not recognize the simplicity of that because I was visually expecting some sort of cursor insert point, but instead it simply highlights the whole column name where upon you can type over it with the column name you want to use.
00:00 Goal
00:42 Create Initial Table
01:25 Identifying Problems in Editing Existing Table
02:25 Power Query Editor
03:40 Edit, Add and Delete a Rows