Forum Discussion

Nreddy's avatar
Nreddy
New Member
3 years ago
Solved

Dynamic connection based on selection on slicer

Hello Folks, I Need help to achieve below Requirement. We do have different region data in different databases and we do have all connection, Username,password details on the metadata database. Th...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Nreddy ，

     

    If you use Direct Query to connect to your data source, I suggest you to try dynamic M query parameters. You can use slicer to get dynamic username and password then pass the data to query by parameter.

    For reference:

    Dynamic M query parameters in Power BI Desktop

    If you use import connection mode, I suggest you to create username and password parameters in M query. Add the parameter into your query as above and you can choose parameter to change your data.

     

    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.

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Nreddy ，

 

If you use Direct Query to connect to your data source, I suggest you to try dynamic M query parameters. You can use slicer to get dynamic username and password then pass the data to query by parameter.

For reference:

Dynamic M query parameters in Power BI Desktop

If you use import connection mode, I suggest you to create username and password parameters in M query. Add the parameter into your query as above and you can choose parameter to change your data.

 

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.