parameter binding is not working for database connection change

[sarankumar01]

I have the single direct query to see the performance with different databases. so I have created the bind parameter to make filter/slicer which contains my database connection name. It is successfully created the bind paramater but when I choose filter/slicer, it is not working, parameter is not changed and the query is not refreshing based on my selection.

can anyone please suggest this is possible in powerbi?

[v-zhangti · Accepted solution]

Hi, @sarankumar01 

Please understand the limitations of the field parameters:

• AI visuals and Q&A aren't supported with the feature.
• There's no way for your report users to select the "none" or no fields option. Selecting no fields in the slicer or filter card is the same as selecting all fields.
• You can't create parameters in live connection data sources without a local model. However, if you use DirectQuery for Power BI datasets and AS (preview), you can add a local model to create field parameters. For more information about using DirectQuery for live connections, see DirectQuery for Power BI datasets and AS (preview).
• You can't use implicit measures, so if you need an aggregated column as one of your fields, you need to create an explicit DAX measure for it. For more information, see implicit vs. explicit measures.
• You can't use field parameters as the linked fields of a drill-through or tooltip page. The workaround is to use the individual fields referenced within the field parameter instead. For example, if your field parameter includes Customer and Product fields, you can link these two fields to your drill-through or tooltip page so that visuals with the field parameter can launch your drill-through or tooltip page.

Let report readers use field parameters to change visuals (preview) - Power BI | Microsoft Learn

Best Regards,

Community Support Team _Charlotte

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