Power BI - Manually typing in a data table
1K views
Oct 18, 2024
Power BI - Manually typing in a data table Watch more Videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Akshay Magre, Tutorials Point India Private Limited
View Video Transcript
0:00
Hello, friends and welcome to Tutorials Point
0:03
In this segment of the video, I'm going to show you how to manually type into a data table
0:09
So guys, once we have created the table, sometimes there is a need to alter the table
0:14
In our previous video, we have already seen how to enter data manually using the Enter Data feature
0:21
Now how it is different out here? The difference in the previous video and this video is that once we have created the table
0:27
we will go ahead and make changes in that feature. particular table so that's what we are going to learn now in order to make
0:34
changes in the into the data table what we need to do is we need to go to the
0:39
power query editor once we have reached the power query editor we have to go
0:43
under the source button and under the source button you will find the way to
0:47
edit the table that we have just created so how to enter the data manually in the
0:52
data table we are going to see it practically in our practical approach
0:56
Hello friends and welcome in this video I'm going to show you how to enter data in the data table that we have already created in Power BI desktop
1:07
Alright, so let's get started off now in order to see the data table we simply have to move under the extreme right side of your screen and out there you will be finding the different tables that we have some of them are imported and some emporated
1:20
Now out of this car sales and Indian states we have created manually using this
1:26
Enter data feature and rest of them have been imported using the access database All right So what will be doing out here the table that we have created we are going to add some more entries to it And how I do that
1:39
It's quite simple. You simply have to go under this Edit Query section and click on it
1:44
The moment I click on it, this Power Query editor will come into picture and out here you can add or you can delete any data from the data table
1:54
So let's go ahead and add some few more states to this Indian state
1:57
right out here you can see there a couple of entries we will go ahead and add
2:01
some more entries and how I do that it's quite simple you simply have to go
2:06
to this applied steps pane and out there you will find the source so if you
2:10
want to go to the source you simply have to click on this gearbox the moment
2:14
I click on this gearbox and create table module will come into picture and out
2:19
here I can simply go ahead and start adding the entries so let's go ahead and
2:24
add some more states let's take go on give it some value right with the Pradesh and we will add some values to this as well okay
2:35
and let's add one more entry West Bengal and give it some value okay now the
2:42
moment you have made the changes you simply have to hit on okay and see what
2:47
happens the moment I hit okay these entries are being added up out here so
2:52
guys this is very simple if you want to add any kind of data in the data tables
2:57
that you have already created you simply have to go to the power query editor and simply click on the
3:03
source tab all right guys so this was all for this video see you until next time
#Business & Productivity Software