Forum Discussion
Single master PBI report for multiple clients
Hi mbravonxp ,
Power Query parameters are inherently static and are evaluated only during dataset refresh, which means they do not update dynamically at runtime based on the logged-in client. This explains why you are not observing the expected dynamic behavior. In an Embedded environment, the recommended method is to define a parameter for the container path in Power Query and have its value provided at runtime by your embedding application. When generating the embed token, you can use the EffectiveIdentity or parameter binding feature to supply the appropriate container path. This ensures that the master report selects the correct container for each client without requiring report duplication or manual parameter changes. If you later move to a semantic layer, you can implement Row Level Security, but dynamic container switching per client is only achievable through dynamic binding in Embedded, not directly via Power Query or DAX.
Thank you,Tejaswi.
Hi v-tejrama,
Thanks a lot for the reply, it sounds quite promissing.
My approach was to create a parameter in Power Query whose value would change depending on the logged client. Following this approach, I am struggling to change the value of the parameter since I cannot achieve its dynamic behavior. How should I proceed?
Hi mbravonxp ,
Power Query parameters are inherently static and are evaluated only during dataset refresh, which means they do not update dynamically at runtime based on the logged-in client. This explains why you are not observing the expected dynamic behavior. In an Embedded environment, the recommended method is to define a parameter for the container path in Power Query and have its value provided at runtime by your embedding application. When generating the embed token, you can use the EffectiveIdentity or parameter binding feature to supply the appropriate container path. This ensures that the master report selects the correct container for each client without requiring report duplication or manual parameter changes. If you later move to a semantic layer, you can implement Row Level Security, but dynamic container switching per client is only achievable through dynamic binding in Embedded, not directly via Power Query or DAX.
Thank you,Tejaswi.
Hi mbravonxp ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.
Thank you,Tejaswi.