Display Record OrganizationID based RLS from MVC C#

[DineshDwilco]

Hi all,

   I displayed power bi Dashboard Report but its shown all the organization Records but I need to display as per Organization Based Records in power bi. I will pass OrganizationID from my MVC C#. is this possible on DirectQuery Dashboard?

How to Achive to RLS based on organizationID from my Application

Guide Me,...

@ibarraza @ibarrau @Anonymous @Burningsuit @GilbertQ @v-ljerr-msft 

Regards

Dinesh D

[Anonymous · Accepted solution]

Not sure I quite understood your problem -
Let me know if this covers your scenario - Using row-level security with embedded content in Power BI embedded analytics - Power BI | Microsoft...

[DineshDwilco]

OrganizationID is the one of the field for my all Dataset. I need to pass that field from my MVC C# application embedd the power BI Report. as per the user logged corresponding Organization in my web application there own Organization Will Display other Organization Records does not shown is this possible?  

[ibarrau]

Hi. I'm not sure I get the issue. You can use RLS in direct query. So if you need to change the data model by filtering something in there, just create RLS and you can use it when calling the token for embedding.

If you talk about changing Organization like the tenant of PowerBi or Azure, you can't. However you could add all data in a single data model filtered by a table of organizations to change between them with RLS.

I hope that helps,