=> Instead I have an existing table which contains data imported from a workbook. One of the columns on this table is IMDB ID.
To create a parameter and give it values from this column. You can refer to following steps:
1. Go to Edit Queries, choose the IMDB ID column, go to Transform -> Convert to List. Then you'll get an signle list with IMDB ID values. Please be noticed, if you want to keep original table, duplicate a table before doing convert. Also you can remove duplicates inside this column. Please refer to following sample:
Original TableConvert column RecordType to List and remove duplicates
2. Create a new parameter, set the Suggested Values to Query (the list we generated above), and give a default value.
3. Close&Apply. Then you can see all the values in the column are in the drop down box of this parameter.