Forum Discussion

malikirfan28's avatar
malikirfan28
Helper II
7 years ago
Solved

Dynamic Data Source based on dynamic parameter from login user session

Hi All, We have mulitple clients with separate copy of exactly same database schema on same SQL Server. I know how to create parameterized query within Power BI Desktop and then build separate copy ...
General Comment
Need Help
Show and Tell
Tips and Tricks
malikirfan28's avatar
malikirfan28
Helper II
7 years ago

Hi GilbertQ ,

Thank you for your support.

However I couldn't understand your point 3 reply. Can you please give some detail. 

 

Thank you.

GilbertQ's avatar
GilbertQ
Super User
7 years ago
Hi there

Currently people who are a member of an App Workspace do not have RLS applied to them when they view the reports or dashboards.
  • malikirfan28's avatar
    malikirfan28
    Helper II
    7 years ago

    Ok, that's not our case because our custom application users are not added in App Workspace. Thank you for clarificaton. 

    I have also implemented your suggested solution and it seems working fine. Just one last point, if we pass Roles information under GenerateToken Request for a dashboard that doesn't enabled RLS, then this throw error 

     

    Exception Details: Microsoft.Rest.HttpOperationException: Operation returned an invalid status code 'BadRequest'

    Source Error:

    Line 81:                 generateTokenRequestParameters = new GenerateTokenRequest("View", null, identities: new List<EffectiveIdentity> { new EffectiveIdentity(username: rlfUserId, roles: new List<string> { "RLS" }, datasets: new List<string> { datasetId }) });
Line 82:             
Line 83:             var token = await client.Reports.GenerateTokenInGroupAsync(wsId, repId, generateTokenRequestParameters);

     

    So does it mean we can only pass "identities" if dashboard has enabled RLS? If yes then is there any better way to find this, before loading dashboard? We can used hard-coded dashboard names in condition at our side which have RLS enabled and then create token but it will become problem to update application everytime whenever we will have new RLS based dashbord. So is there any (automatic) bettter & professional way? 

     

    Thank you