Forum Discussion

wynhopkins's avatar
wynhopkins
Icon for Most Valuable Professional rankMost Valuable Professional
9 years ago

Analyze in Excel - users don't require Pro Licence for Row Level Security to work

Hi All

 

I'd just like to clarify that a process I have working is correct.

 

I've created a Power BI report and set up some Row Level Security

 

I've created an Excel Report linked to PowerBI using Analyze in Excel

 

Another user has then opened the file and when they refresh the file the Row Level Security works, they only see the data they are meant to.  This is great.

 

However, that user does not have a Pro Licence so I didn't expect it to let him refresh (Given RLS is a Pro feature)

 

Just checking if this is "normal".  Awesome if it is.

 

Thanks

 

Wyn

Need Help

7 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago


    wynhopkins,

    Do you firstly share dashboard to your users and then the users use the “Analyze in Excel” feature? In Power BI, both Peer-to-peer dashboard sharing and RLS are limited to Power BI Pro. Do your users have Pro trial? If the users are Power BI free users, they are not able to view the contents in the shared dashboard.


    Regards,
    Lydia

    • wynhopkins's avatar
      wynhopkins
      Icon for Most Valuable Professional rankMost Valuable Professional
      9 years ago

      Hi Lydia

       

      I set up a Content Pack and pulled that content pack into a group which I made that user a member of.

       

      They don't have a pro licence so they can't get into that workspace.

       

      I then linked to the data in that workspace using Analyze in Excel

       

      I shared the Excel file with the user and they could refresh the Excel file and the row level security was applied.

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        wynhopkins,

        Firstly, content pack is deprecated, which is replaced by Power BI apps.

        Secondly, do you create the content pack in a app workspace or "My workspace"?

        Thirdly,  you publish the content pack to a specific group that the user belongs to, right? If so, when you share the Excel file to the user, does the user use your Power BI account or his own Power BI account to connect to the dataset in Power BI Service?

        Reagrds,