Forum Discussion

laikittmun's avatar
laikittmun
Frequent Visitor
4 years ago

Row level security is not working in Analyze in Excel

Hi,   I have a dataset that with RLS Roles and rules defined at the Power BI desktop and publish to the service. After that I have assign users/groups to the Roles that available in the datasets. T...
Need Help
laikittmun's avatar
laikittmun
Frequent Visitor
4 years ago

For my understanding, the RLS should work in the Analyze in Excel for VIewer. But it is not right now!  Could anyone advise which part that I should look into to figure out where went wrong ?

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    4 years ago

    Check your data model. Make sure there are no arrows pointing to the RLS table.

  • v-easonf-msft's avatar
    v-easonf-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi, laikittmun 

    Yes , the RLS should work in both report and Analyze in Excel for Viewer. 

    If RLS works on PowerBI Service, it should also work when do Analyze in Excel for that dataset. 

    Please recheck the account you used for tested with the Analyze in Excel.

     

    Best Regards,
    Community Support Team _ Eason