Dynamic Parameter Setup to Denodo in Power BI

[Vasanthrk]

Hi Team,

I am creating reusable template in Power BI, I want to setup Dynamic parameter connection for Denodo, I tried multiple ways but not able to setup that, able to set for source file.now using ODBC to connect Denodo from POwer BI. please provide clear steps to setup the Parameters.

Thanks

Rk

[v-tejrama]

Hi @Vasanthrk 

Thak you for using Microsoft Fabric Community Forum!

To set up a dynamic parameter connection to Denodo in Power BI using ODBC, first create parameters in Power BI (such as DSN name, database name, or query filters) by going to Manage Parameters. Then, use these parameters within Power Query to build your ODBC connection string or embed them in a native SQL query using Value.NativeQuery. For example, you can construct the connection like: Odbc.DataSource("dsn=" & DSNName) and pass parameters dynamically to the SQL query for filtering. This setup supports dynamic input during data load, not during report interaction. To make the report reusable, export it as a Power BI template (.pbit), which will prompt users to enter parameter values when opening the report. Note that this works best in Import mode or with DirectQuery if query folding is preserved.

Thanks for reaching out! If this answer was helpful, please consider marking it as Accepted Solution and giving a Kudos, it helps the community!

Thankyou,

Tejaswi

Community Support Team.

[v-tejrama]

Hi @Vasanthrk , 

As we have not received a response from you yet, I would like to confirm whether you have successfully resolved the issue or if you require further assistance.

If the issue has been resolved, please mark the helpful reply as a "solution" to indicate that the question has been answered and to assist others in the community.

Thank you for your cooperation. Have a great day.

[v-sgandrathi]

Hi @Vasanthrk,

We haven’t heard from you on the last response and was just checking back to see if your query was answered.
Otherwise, will respond back with the more details and we will try to help .

If our response has addressed your query, please accept it as a solution and give a ‘Kudos’ so other members can easily find it. Please let us know if there’s anything else we can do to help.

Thank you.

[v-tejrama]

Hi @Vasanthrk, 

Since we haven't heard back from you yet, I'd like to confirm if you've successfully resolved this issue or if you need further help?
If you've already resolved the issue, you can mark the helpful reply as a "solution" so others know that the question has been answered and help other people in the community. Thank you again for your cooperation!
If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.

Thank you,
Tejaswi.

[burakkaragoz · Accepted solution]

Hi @Vasanthrk ,

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

[Akash_Varuna]

Hi @Vasanthrk For this, you need to create parameters in Manage Parameters for the Denodo server, port, database, and query. Use these in Power Query to build a dynamic connection string and then reference the parameters in your query.