Dynamic Parameter Setup to Denodo in Power BI

Setting up dynamic parameters with Denodo in Power BI can be a bit tricky since native parameter pushdown support is limited depending on how you're connecting (ODBC vs DirectQuery).

Here’s a general approach that might help:

1. Create a parameter in Power BI (e.g. RegionParam).
2. Use that parameter in a custom SQL query when connecting to Denodo, like:

SELECT * FROM your_view WHERE region = '@RegionParam'

1. If you're using DirectQuery, make sure the parameter is tied to a slicer or a table so it updates dynamically.
2. Also, check that query folding is preserved — sometimes Power BI pulls all data and filters later, which defeats the purpose.

If you're still stuck, let me know how you're connecting (ODBC, JDBC, etc.) and what kind of error or behavior you're seeing — happy to help more!

If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.
translation and formatting supported by AI