Forum Discussion

gsoriot's avatar
gsoriot
Frequent Visitor
2 years ago

Excel online file connected to a Power BI Dataset with RLS

Hello,   I created a dataset & report, where I defined RLS, with Power BI that I published in a workspace on Power BI Service.  I then connected this dataset to an Excel Online file that I deposed...
Need Help
gsoriot's avatar
gsoriot
Frequent Visitor
2 years ago

Hello aj1973 ,

 

No attached limitations aren't applied to my case.
-> RLS a OK when viewers accessed to a Power BI report, but are KO (they can access to all the data) when they access to an Excel which is connected to my Power BI Dataset.

aj1973's avatar
aj1973
Icon for Community Champion rankCommunity Champion
2 years ago

Remove all users from the workspace.

Go to Dataset and use Manage permission to give access to your users with Build permission.

Ask the user to use Excel to connect to the dataset.

Let me know

  • gsoriot's avatar
    gsoriot
    Frequent Visitor
    2 years ago

    Hi aj1973 ,

    Unfortunately, I have the same problem again ...