Forum Discussion

EshaanG's avatar
EshaanG
Helper I
5 years ago
Solved

RLS on PowerBI Dataset

I am trying to apply RLS on a imported dataset which is connected to a PowerBI Dataset (Composite Model). However, the RLS works on the PowerBI Dataset only when the connection field (Geo/Region) is ...
Data Protection
Need Help
Show and Tell
  • v-xiaotang's avatar
    v-xiaotang
    5 years ago

    Hi EshaanG 

    I attached my sample file bellow.

     

    Best Regards,

    Community Support Team _ Tang

    If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

v-xiaotang's avatar
v-xiaotang
Community Support
5 years ago

Hi EshaanG 

I create a sample file connected to Power BI Dataset for test, however, in Manage Roles Tab I can’t find tables. So could you kindly share the sample file after removing sensitive information?

Besides, I create a sample file under import mode. In this case, it works OK.

Result：

 

Best Regards,

Community Support Team _ Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

  • EshaanG's avatar
    EshaanG
    Helper I
    5 years ago

    Thanks for the response! The RLS does work with imported tables but not with a Direct Query to PowerBI Dataset. In my case the "rls" table is imported but the "Deal_Band.." table is a direct query to a PBI Dataset owned by someone else.

     

    As you already noticed, the PBI Dataset does not show up in the Manage Roles section and therefore my rule is setup on the imported "rls" table. Ideally, when the "rls" table gets filtered by a role it should filter the connected PBI dataset and show visuals on that. However, it only does that when the joined field is present in the visual

     

    Unfortunately, I cannot share a sample file because I don't own the PBI dataset. I really want to understand why the visual does not work when the joined field is not in it!

    • v-xiaotang's avatar
      v-xiaotang
      Community Support
      5 years ago

      Hi EshaanG 

      Thanks for your reply.

      I test again, import table rls and get Table from Power BI dataset, amazingly it works OK also…

      Here are my operating screenshots:

      Manage roles,

      Then, view as APAC,

      Or is there anything let out?

       

      Best Regards,

      Community Support Team _ Tang

      If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

      • EshaanG's avatar
        EshaanG
        Helper I
        5 years ago

        This looks great but somehow it does not work on my side. The visual on the left which does not have Geo in it does not get affected by RLS. Can you please share the .pbix file and I can compare if there are any issues with my setup?