Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Row Level Security on Composite Model

Hello,   In my report, I have connected to SSAS cubes data, Power BI dataset and Sharepoint data. 1.Imported one table of suppliers with Supplier ID from SSAS cube and direct queried other tables ...
Need Help
ABI_Rufino's avatar
ABI_Rufino
Advocate I
3 years ago

I have the same exact problem.

 

My scenario is:

 

  • Power BI Premium Workspace;
  • Composite model with:
    • Power BI Dataset Direct Query (AS) - let's call it 'base dataset'
    • Excel file on Sharepoint folder;
      • Only 2 columns: user email and the region that i want to filter;
    • The excel file relationship is with the dimension as a many-to-many, one-directional (excel filters the dimension);
  • RLS rule is simple: [user_email] = USERPRINCIPALNAME(), so when user is logged to PBI Service the excel table is filtered and it SHOULD filter the dimensions table, and them filtering the fact table;

RLS works fine if i import the excel file to the 'base dataset'. But i don't want that because it's a shared dataset and RLS will apply only to a few reports, not all of them. So for those that will apply, i've created this composite model, but for some reason the RLS rules are not working (the excel table is being filtered, but the filter is not propagating).

  •  
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi,
RLS is still not working for me on composite model, but we have implemented alternate solution which is filtering report by passing query string parameter. Our report is embedded in the external portal so we have added query string parameter in the embed link and its working for the users, we have kept is as a temporary solution for now. You can refer the link below:
Filter a report using query string parameters in the URL - Power BI | Microsoft Learn