Run multiple queries during drilldown and use selected elements from visual in SQL-where clause

Hallo ,

recently I found some time to continue my evaluation of Power BI .

Your Text.From([Parameter]) gives an error see screenshot.

But when I encode my parameter values with single quotes like P_ISO_WEEK_OF_YEAR = '2022-30'
then the m-query code works.

Currently I am having problems getting values into the parameter dynamically.

There are two things :

* I cannot use 'BIND to parameter' for a column,  because it is not available
in modelling columns -> Advanced part in my Power BI desktop for any table and any column, even
if I am using <Direct Query>.

* Also the "preview feature" is not available in my power bi desktop version under

File -> Options and Settings -> Options

It should be between <Diagnostics and Settings> and <Auto Recovery> according to some other posts but it is not there in my version.

So my questions are :

Is this "bind to parameter feature" not availabe for Power BI Desktop Version: 2.97.802.0 64-bit (September 2021) ?

Unfortunately I receive Power BI Desktop with company software distribution, and they are always a bit behind in versions.

Is this "bind to parameter feature" not availabe for Datasource = PostgreSQL 13 with mode = <Direct Query> ?

Why do I not have this "Preview option" in File -> Options and Settings -> Options ?

Am I doing something wrong, which you could correct ?

Many thanks for your answers in advance, Horst