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.
