How to make Table of fixed values

[croberts21]

SUPERCEDED BY A NEW QUESTION. Please ignore this question.

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 make a table of fixed values. The columns are: Payrollcode (a number) and ShortDesc (a short description of the payroll code which will be displayed to the user), LongDesc (a longer description). Some example values: 

1	REG	Regular time
2	OT	Overtime
3	DBL	Double time

The database stores the codes, but I want my report to show the short description. I've been searching for videos on this and have not found one yet. Most videos are about creating a table with a calculated column. I don't want a calculated column, my columns will all be entered manually and will not change based on data in another table.

On the Data tab (far left) I have clicked New Table then entered this command:

#table(
//column headers
{"Payrollcode","ShortDesc","LongDesc"},
//row content
{
{"1","REG","Regular time"},
{"2","OT","Over time"},
{"3","DBL","Double time"}
}
)

But I get the error "To use special characters in a calculated table name, enclose the entire name in brackers ([]) and add a ] to any closing brackets in the name."

Thank you!

[PaulDBrown]

Can you post a sample PBIX file or sample data?

[croberts21 · Accepted solution]

I think I found something. I found on the Viz tab (far left), Home tab bar, there is Enter Data. I will try that.

[croberts21]

How do I post a PBIX file here? All forums are different and I don't see a way to attach a file to a reply.

[PaulDBrown]

You can upload it to a cloud service (OneDrive, Google Drive, Icloud...) and share the download link to file from there