Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
User | Count |
---|---|
5 | |
4 | |
3 | |
2 | |
2 |
User | Count |
---|---|
8 | |
6 | |
4 | |
4 | |
4 |