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.
Hi,
I'm new to the PBI services so my question might be a bit silly but I'm a bit lost.
TLDR
Is it possible to pass parameter to the SQL query from the app over the PBI API to display the report? What would be the best way to do that?
Current stack
Goal
When the user logs in the app knows the group ID he belongs to. The displayed report should be based on that specific ID and the user should not be able to see any other results.
I imagined something like:
This might be not the best approach but how could we achieve that? Is it even possible to dynamically update the SQL query from the app/API?
if not, how could I display the data based on the user's role?
Thank you in advance,
Regards
David
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 |
---|---|
12 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
23 | |
3 | |
2 | |
2 | |
2 |