M Query dynamic Parameter - Filtering on query based on another query

[Anonymous]

Hi, 

I have a table Table 1 in a Snowflake DB that contains the control columns like role, database, schema. I want to query this table, fetch the  database, schema information. store it in different parameters (dbparam, schemaparam). 

Then I want to retrieve Table 2 information with Dyanamic M Query using the databaseparam and schemaparam set in the param values. 

For this, I setup the first M Query datasource to fetch Table 1 value. 

I have created the 2 parameters. 

However, I am not able to get the Table 1 database and schema column values to influence the 2 parameters. 

Pls advice how this can be done. 

Regards

Vicha 

[Anonymous]

On your second point. I just wanted to say somehting i missed.

I have set up an RLS based on which the Table 1 is filtered and selected. There is no slicer. 

[lbendlin]

I don't think RLS and dynamic parameters are compatible.

[lbendlin]

Sounds like you missed a couple of steps

- bind the parameters to their respective columns

- make sure that both columns are set up as single select slicers.

- create a native query with folding enabled that utilizes these parameters.