Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
The requirement is
In slicer (Region) if we select US than I will query from metadata and get the connection details and get connected to that Us database and fetch the us related data.
I'm completely lost and any help is much appreciated.
Thanks,
Naveen
Solved! Go to Solution.
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
15 | |
1 | |
1 | |
1 | |
1 |
User | Count |
---|---|
26 | |
3 | |
2 | |
2 | |
2 |