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 ...
Need Help
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,

  • wynhopkins's avatar
    wynhopkins
    Icon for Most Valuable Professional rankMost Valuable Professional
    9 years ago
    Hi, I thought apps were still in preview given some of the limitations that have not been implemented yet (e.g. Can't select elements to share in a workspace so have to share all or nothing?)

    I set up the content pack in an app workspace, the user does have a free power bi account
    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      wynhopkins,

      I am not able to reproduce your issue. When you share the dashboard to your users, please verify that if the free users can view the dashboard contents. And please check if the free users can import content pack to their own workspace.

      By the way, do you purchase Power BI Premium in your organization?

      Regards,

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

        Hi 

         

        Free users cannot view the dashboards in Power BI Service,

         

        The organisation does not have Power BI Premium.

         

        Thanks for your assistance, I'm happy that it is working the way it is.