Forum Discussion

PaulMGNT's avatar
PaulMGNT
Frequent Visitor
3 years ago
Solved

RLS Security with Direct Query to PBI Cube

Hi all,   I am currently working and using a PBI with RLS security (username()). This PBI model and security work well.   But I am deploying a new report built with a direct connection to my exis...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi PaulMGNT 

    If you previously defined roles and rules in the Power BI service, you must re-create them in Power BI Desktop, you need to set new RLS for the new report on the desktop, the original RLS is set for your power bI model. You can refer to the following link of RLS limiation:

    https://learn.microsoft.com/en-us/power-bi/enterprise/service-admin-rls#considerations-and-limitations

     

    Best Regards!

    Yolo Zhu

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

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi PaulMGNT 

If you previously defined roles and rules in the Power BI service, you must re-create them in Power BI Desktop, you need to set new RLS for the new report on the desktop, the original RLS is set for your power bI model. You can refer to the following link of RLS limiation:

https://learn.microsoft.com/en-us/power-bi/enterprise/service-admin-rls#considerations-and-limitations

 

Best Regards!

Yolo Zhu

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