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 All,
Currently I am using App own Data approach for Embedding Power BI report in my application.
As a requirement, I want to implement dynamic source query using Direct Query as a Connection. Such that when user click on "View Report" for any particular ID from Website, it should pass the ID value as a parameter to the Power BI Report source query(Refer the below query).
" Select F.* from FactTable left outer join Main_" &ID&""
So in above scenario, I am changing the secondary table based on the ID passed by user from website.
Note : 1. Multiple users can access the same report at a same time with different ID respectively.
2. Due to large Dataset, I need to use Direct query instead of Import
Qtn 1: Is it even possible to access same dataset by multiple end users by passing different IDs to source query.
Qtn 2: If yes, Please suggest the solution or method to implement.
If you have any other approach for above problem statement, Please suggest.
Thank you all in Advance.
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 |
---|---|
13 | |
2 | |
2 | |
1 | |
1 |
User | Count |
---|---|
20 | |
3 | |
2 | |
2 | |
2 |