Hi All
I would like to integrate Power BI RLS with ADX RLS. Would anyone have any ideas on how to achieve this?
I can see how I can use the current_principal() and other methods within a kusto query to enable the RLS (https://docs.microsoft.com/en-us/azure/data-explorer/kusto/management/rowlevelsecuritypolicy). However, I am running Power BI in an embedded environment and therefore the current_principal() will always be the same.
Would any one know if it is possible to pick up a value passed in from a server side call to the PowerBIClient.Reports.GenerateTokenInGroupAsync method (or similar) and have that value picked up securely from within a Kusto stored function so that the value can be treated as a customer Id and be used as the row level security filter?
Thanks in advance
JBD