Forum Discussion
How to add connector combo box in report
Hi,
I migrate ssrs report to power bi desktop but i have new challenge. Actually, we can choice environnement with a select box and this last one change the data connector(teradata) but, we can do this like with ssrs in power bi.
so, i wonder if it's possible with power bi desktop or i'm just in the wrong way.
regards
Hi jdgenest ,
Here I suggest you to try Parameter in Power BI Desktop.
Current the slicer and filter not able to directly interact with the backend query tables connection string.
You can change the data source in Power Query Editor or Power BI Service Parameter Selection.
Parameters give you the flexibility to dynamically change the output of your queries depending on their value, and can be used for:
- Changing the argument values for particular transforms and data source functions.
- Inputs in custom functions.
For reference: Parameters - Power Query | Microsoft Learn
You can refer to this blog to learn more details about how to configure:
Using the Power BI Service Parameters to change co... - Microsoft Fabric Community
How to Parameterize Data Sources in Power BI | phData
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi jdgenest ,
Here I suggest you to try Parameter in Power BI Desktop.
Current the slicer and filter not able to directly interact with the backend query tables connection string.
You can change the data source in Power Query Editor or Power BI Service Parameter Selection.
Parameters give you the flexibility to dynamically change the output of your queries depending on their value, and can be used for:
- Changing the argument values for particular transforms and data source functions.
- Inputs in custom functions.
For reference: Parameters - Power Query | Microsoft Learn
You can refer to this blog to learn more details about how to configure:
Using the Power BI Service Parameters to change co... - Microsoft Fabric Community
How to Parameterize Data Sources in Power BI | phData
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.