Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How to parameterize an odbc.query with a parameter restricted to a column from the same sql source ?

Hello,   I have defined a Power Query parameter called "MyParameter" whose values are restricted to a list "ListOfPossiblesValues" obtained by quering a table from a PostgreSQL database :    Odb...
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

     

    Dynamic M query parameters feature is in preview. Please refer to offical blog for more details about Considerations and limitations.

     

    • A single parameter cannot be bound to multiple fields nor vice-versa.

    • Aggregations are not supported with the feature

    • Row-level security (RLS) is not supported with the feature

    • ...

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.