The lookup query is not intended to be used for security purposes. The BI Portal includes security features to control data access, based on users and groups.

A common use for this functionality is to limit the dates that are presented to a user in a parameter value selection. It is good practice to create a general lookup queries to be used in many reports.