Forum Discussion
How to edit a table created with "Enter Data".
I'm still pretty new to PBI. I have Free PBI Desktop v2.102.845 (64 bit free version Feb 2022) on Windows 10. I use an ODBC driver to connect to a Postgresql database server.
I need to enter some fixed values into a table which will never change. The columns with sample data are like this:
| Payrollcode | ShortDesc | LongDesc |
| 1 | REG | Regular Time |
| 2 | OT | Over Time |
| 3 | DBL | Double time |
- This table will connect the column Payrollcode to another table, so I can show ShortDesc in my actual reports.
- This manually entered table will probably be used in many PBIX files.
- I need to be able to name the columns "Payrollcode", "ShortDesc" and "LongDesc".
I have entered several rows of data already via Home tab bar, and Enter Data, but I am unable to enter the rest of the codes. How do I edit this manually entered table? I have tried right-clicking the table and selecting "Edit query". I can see the rows I entered but cannot add more rows to the query. I am also unable to change the column names which are currently "Column1", "Column2", and "Column3".
Thank you!
croberts21 , In power query double click on source, you will get the table to edit
How to Enter Data and Edit it: https://youtu.be/5nE7YGT72kU
3 Replies
- croberts21
Continued Contributor
More info: If I right click the table on the far right of the PBI window, then choose Edit Query, I'm in the Power Query editor.
- amitchandak
Super User
croberts21 , In power query double click on source, you will get the table to edit
How to Enter Data and Edit it: https://youtu.be/5nE7YGT72kU
- croberts21
Continued Contributor
Oh, that's under Applied Steps on the right. Got it. Thanks!